CHECK FOR DISABLED TRIGGERS

SELECT owner || '.' || trigger_name trigger_name,
 table_owner || '.' || table_name table_name
FROM dba_triggers
WHERE status = 'DISABLED'
ORDER BY owner, table_name;