Oracle PL/SQL Tutorial/System Tables Data Dictionary/user plsql object settings

Query user_plsql_object_settings

SQL>
SQL>
SQL> COLUMN NAME FORMAT A30
SQL> COLUMN plsql_ccflags FORMAT A30
SQL>
SQL> ALTER SESSION SET plsql_ccflags = "app_debug:TRUE";
Session altered.
SQL>
SQL> CREATE OR REPLACE PROCEDURE test_ccflags
  2  IS
  3  BEGIN
  4     NULL;
  5  END test_ccflags;
  6  /
Procedure created.
SQL>
SQL> SELECT name, plsql_ccflags
  2    FROM user_plsql_object_settings
  3   WHERE NAME LIKE "%CCFLAGS%";
NAME                           PLSQL_CCFLAGS
------------------------------ ------------------------------
TEST_CCFLAGS                   app_debug:TRUE
TEST_CCFLAGS_NEW               app_debug:FALSE

SELECT owner, NAME, plsql_warnings FROM user_plsql_object_settings

SQL> SELECT owner, NAME, plsql_warnings
  2    FROM user_plsql_object_settings
  3   WHERE plsql_warnings LIKE "%DISABLE%"
  4     AND owner NOT IN ("SYS", "SYSTEM");
   AND owner NOT IN ("SYS", "SYSTEM")
SQL>
SQL>