SELECT owner, NAME, plsql_warnings FROM user_plsql_object_settings : user_plsql_object_settings « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. 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>