DBA_PLSQL_OBJECT_SETTINGS view tips

Oracle Tips by Burleson Consulting

DBA_PLSQL_OBJECT_SETTINGS

<< Return to the index

Oracle 11g makes the following comments about the DBA_PLSQL_OBJECT_SETTINGS table: "Compiler settings of all objects in the database"

Related notes on DBA_PLSQL_OBJECT_SETTINGS:

Oracle DBA View List

Column description of the DBA_PLSQL_OBJECT_SETTINGS view:

OWNER

Description of DBA_PLSQL_OBJECT_SETTINGS.OWNER: "Name of the user whose privileges the DAD is authorized to use"

NAME

Description of DBA_PLSQL_OBJECT_SETTINGS.NAME: "Name of the object"

TYPE

Description of DBA_PLSQL_OBJECT_SETTINGS.TYPE: "Type of the object: "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "TRIGGER", "TYPE" or "TYPE BODY""

PLSQL_OPTIMIZE_LEVEL

Description of DBA_PLSQL_OBJECT_SETTINGS.PLSQL_OPTIMIZE_LEVEL: "The optimization level to use to compile the object"

PLSQL_CODE_TYPE

Description of DBA_PLSQL_OBJECT_SETTINGS.PLSQL_CODE_TYPE: "The object codes are to be compiled natively or are interpreted"

PLSQL_DEBUG

Description of DBA_PLSQL_OBJECT_SETTINGS.PLSQL_DEBUG: "The object is to be compiled with debug information or not"

PLSQL_WARNINGS

Description of DBA_PLSQL_OBJECT_SETTINGS.PLSQL_WARNINGS: "The compiler warning settings to use to compile the object"

NLS_LENGTH_SEMANTICS

Description of DBA_PLSQL_OBJECT_SETTINGS.NLS_LENGTH_SEMANTICS: "The NLS length semantics to use to compile the object"

PLSQL_CCFLAGS

Description of DBA_PLSQL_OBJECT_SETTINGS.PLSQL_CCFLAGS: "The conditional compilation flag settings to use to compile the object"

PLSCOPE_SETTINGS

Description of DBA_PLSQL_OBJECT_SETTINGS.PLSCOPE_SETTINGS: "Settings for using PL/Scope"

DBA_PLSQL_OBJECT_SETTINGS View Source

Oracle 11g's data dictionary defines the DBA_PLSQL_OBJECT_SETTINGS view using the following source query:

select u.name, o.name,
decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
11, 'PACKAGE BODY', 12, 'TRIGGER',
13, 'TYPE', 14, 'TYPE BODY', 'UNDEFINED'),
(select to_number(value) from settings$ s
where s.obj# = o.obj# and param = 'plsql_optimize_level'),
(select value from settings$ s
where s.obj# = o.obj# and param = 'plsql_code_type'),
(select value from settings$ s
where s.obj# = o.obj# and param = 'plsql_debug'),
(select value from settings$ s
where s.obj# = o.obj# and param = 'plsql_warnings'),
(select value from settings$ s
where s.obj# = o.obj# and param = 'nls_length_semantics'),
(select value from settings$ s
where s.obj# = o.obj# and param = 'plsql_ccflags'),
(select value from settings$ s
where s.obj# = o.obj# and param = 'plscope_settings')
from sys."_CURRENT_EDITION_OBJ" o, sys.user$ u
where o.owner# = u.user#
and o.type# in (7, 8, 9, 11, 12, 13, 14)

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books