ALL_APPLY

Details about each apply process that dequeues from the queue visible to the current user

Columns
   ___________________________
 
   APPLY_NAME
      Name of the apply process
   QUEUE_NAME
      Name of the queue the apply process dequeues from
   QUEUE_OWNER
      Owner of the queue the apply process dequeues from
   APPLY_CAPTURED
      Yes,if applying captured messages; No,if applying enqueued messages
   RULE_SET_NAME
      Rule set used by apply process for filtering
   RULE_SET_OWNER
      Owner of the rule set
   APPLY_USER
      Current user who is applying the messages
   APPLY_DATABASE_LINK
      For remote objects,the database link pointing to the remote database
   APPLY_TAG
      Tag associated with DDL and DML change records that will be applied
   DDL_HANDLER
      Name of the user specified ddl handler
   MESSAGE_HANDLER
      User specified procedure to handle messages other than DDL and DML messages
   STATUS
      Status of the apply process: DISABLED,ENABLED,ABORTED

Related:

Simon Sheppard
SS64.com