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; |
|