ALL_APPLY_DML_HANDLERS

Details about the dml handler on tables visible to the current user

Columns
   ___________________________
 
   OBJECT_OWNER
      Owner of the object
   OBJECT_NAME
      Name of the object
   OPERATION_NAME
      Name of the DML operation
   USER_PROCEDURE
      Name of the DML handler specified by the user
   ERROR_HANDLER
      Y if the user procedure is the error handler,N if it is the DML handler
   APPLY_DATABASE_LINK
      For remote objects

Related:

Simon Sheppard
SS64.com