| |
 |
|
DBA_STORED_SETTINGS view tips
Oracle Tips by Burleson Consulting |
DBA_STORED_SETTINGS
<< Return to the index
Oracle 11g makes the following comments about the DBA_STORED_SETTINGS table: "Parameter settings for all objects"
Related notes on DBA_STORED_SETTINGS:
Column description of the DBA_STORED_SETTINGS view:OWNERDescription of DBA_STORED_SETTINGS.OWNER: "Username of the owner of the object" OBJECT_NAMEDescription of DBA_STORED_SETTINGS.OBJECT_NAME: "Name of the object" OBJECT_IDDescription of DBA_STORED_SETTINGS.OBJECT_ID: "Object number of the object" OBJECT_TYPEDescription of DBA_STORED_SETTINGS.OBJECT_TYPE: "Type of the object" PARAM_NAMEDescription of DBA_STORED_SETTINGS.PARAM_NAME: "Name of the parameter" PARAM_VALUEDescription of DBA_STORED_SETTINGS.PARAM_VALUE: "Value of the parameter"
DBA_STORED_SETTINGS View SourceOracle 11g's data dictionary defines the DBA_STORED_SETTINGS view using the following source query:
SELECT u.name, o.name, o.obj#,
DECODE(o.type#,
7, 'PROCEDURE',
8, 'FUNCTION',
9, 'PACKAGE',
11, 'PACKAGE BODY',
12, 'TRIGGER',
13, 'TYPE',
14, 'TYPE BODY',
'UNDEFINED'),
p.param, p.value
FROM sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.settings$ p
WHERE o.owner# = u.user#
AND o.linkname is null
AND p.obj# = o.obj#
 |
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
|
|
