dba_apply_dml_handlers

The following SQL statement shows details of DML Handlers on the apply side:

COLUMN OBJECT_OWNER HEADING 'Table|Owner' FORMAT A8
COLUMN OBJECT_NAME HEADING 'Table Name' FORMAT A16
COLUMN OPERATION_NAME HEADING 'Operation' FORMAT A10
COLUMN USER_PROCEDURE HEADING 'Handler Procedure' FORMAT A40
COLUMN APPLY_NAME HEADING 'Apply Proc|Name' FORMAT A15
COLUMN ERROR_HANDLER HEADING 'Error|Hndlr' FORMAT A5

SELECT OBJECT_OWNER, OBJECT_NAME, OPERATION_NAME, USER_PROCEDURE,
APPLY_NAME, ERROR_HANDLER FROM DBA_APPLY_DML_HANDLERS
ORDER BY OBJECT_OWNER, OBJECT_NAME
/

While querying the same view, to display the details of the pre-commit handlers, use the following SQL statement:

COLUMN APPLY_NAME HEADING 'Apply Process Name' FORMAT A20
COLUMN PRECOMMIT_HANDLER HEADING 'Precommit Handler' FORMAT A30
COLUMN APPLY_CAPTURED HEADING 'Type of|Events|Applied' FORMAT A15