CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle PL/SQL Object Settings
Version 11.1
 
conn / as sysdba

desc dba_plsql_object_settings

set linesize 121

-- objects types where warnings can be accessed by owner
SELECT DISTINCT type
FROM dba_plsql_object_settings
ORDER BY 1;

SELECT DISTINCT owner, type
FROM dba_plsql_object_settings
ORDER BY 1,2;

-- available optimizer levels ... requires 2
SELECT DISTINCT owner, plsql_optimize_level
FROM dba_plsql_object_settings;

-- current optimizer level for the instance
SELECT name, value
FROM gv$parameter
WHERE name = 'optimizer_dynamic_sampling';

-- compilation can be INTERPRETED or NATIVE
col plsql_code_type format a30

SELECT DISTINCT owner, plsql_code_type
FROM dba_plsql_object_settings
ORDER BY 1,2;

-- were objects compiled in debug mode?
col plsql_debug format a30

SELECT DISTINCT owner, plsql_debug
FROM dba_plsql_object_settings
ORDER BY 1;

-- what warnings are in place
col plsql_warnings format a50

SELECT DISTINCT owner, plsql_warnings
FROM dba_plsql_object_settings
ORDER BY 1;

-- length semantics for objects
col nls_length_semantics format a30

SELECT DISTINCT owner, nls_length_semantics
FROM dba_plsql_object_settings
ORDER BY 1;
 
Related Topics
DBMS_WARNING
Functions
Packages
Procedures
Table Triggers
Types
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [74 users online]    © 2010 psoug.org