Table: DBA_CAPTURE
Details about the capture process
| Column Name | Description |
|---|---|
| APPLIED_SCN | Everything up to this SCN has been applied |
| CAPTURED_SCN | Everything up to this SCN has been captured |
| CAPTURE_NAME | Name of the capture process |
| LOGMINER_ID | Session ID of LogMiner session associated with the capture process |
| QUEUE_NAME | Name of queue used for holding captured changes |
| QUEUE_OWNER | Owner of the queue used for holding captured changes |
| REQUIRED_CHECKPOINT_SCN | the safe SCN at which the meta-data for the capture process can be purged |
| 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 |