DBA_CAPTURE

Details about the capture process

Columns
   ___________________________
 
   CAPTURE_NAME
      Name of the capture process
   QUEUE_NAME
      Name of queue used for holding captured changes
   QUEUE_OWNER
      Owner of the queue used for holding captured changes
   RULE_SET_NAME
      Rule set used by capture process for filtering
   RULE_SET_OWNER
      Owner of the rule set
   START_SCN
      The SCN from which capturing will be resumed
   STATUS
      Status of the capture process: DISABLED,ENABLED,ABORTED
   CAPTURED_SCN
      Everything up to this SCN has been captured
   APPLIED_SCN
      Everything up to this SCN has been applied

Related:

Simon Sheppard
SS64.com