Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_CAPTURE

Details about each capture process that stores the captured changes in a queue visible to the current user

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

Related:



Simon Sheppard
SS64.com