Query dba_triggers : dba_triggers « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. dba_triggers

SQL>
SQL> SELECT owner, trigger_name, trigger_type,
  2         triggering_event, table_owner||'.'||table_name
  3  FROM   dba_triggers
  4  WHERE  status <> 'ENABLED'
  5  AND    owner  = 'PLSQL_USER'
  6  and    rownum < 2
  7  ORDER BY owner, trigger_name;

no rows selected

SQL>
SQL>