DBA_CAPTURE

Tuesday, September 23, 2008

DBA_CAPTURE

DBA_CAPTURE displays information about all capture processes in the database. Its columns are the same as those in ALL_CAPTURE.

Related View

ALL_CAPTURE displays information about the capture processes that enqueue the captured changes into queues accessible to the current user.

Column	Datatype	NULL	Description
`CAPTURE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the capture process
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue used for staging captured changes
`QUEUE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue used for staging captured changes
`RULE_SET_NAME`	`VARCHAR2(30)`		Name of the positive rule set used by the capture process for filtering
`RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the positive rule set
`CAPTURE_USER`	`VARCHAR2(30)`		Current user who is enqueuing captured messages
`START_SCN`	`NUMBER`		System change number (SCN) from which the capture process will start to capture changes
`STATUS`	`VARCHAR2(8)`		Status of the capture process: · `DISABLED` · `ENABLED` · `ABORTED`
`CAPTURED_SCN`	`NUMBER`		System change number (SCN) of the last redo log record scanned
`APPLIED_SCN`	`NUMBER`		System change number (SCN) of the most recent message dequeued by the relevant apply processes. All changes below this SCN have been dequeued by all apply processes that apply changes captured by this capture process.
`USE_DATABASE_LINK`	`VARCHAR2(3)`		Indicates whether the source database name is used as the database link to connect to the source database from the downstream database (`YES`) or not (`NO`). If the capture process was created at the source database, then this column will be null.
`FIRST_SCN`	`NUMBER`		System change number (SCN) from which the capture process can be restarted
`SOURCE_DATABASE`	`VARCHAR2(128)`		Global name of the source database
`SOURCE_DBID`	`NUMBER`		Database ID of the source database
`SOURCE_RESETLOGS_SCN`	`NUMBER`		Resetlogs system change number (SCN) of the source database
`SOURCE_RESETLOGS_TIME`	`NUMBER`		Resetlogs time of the source database
`LOGMINER_ID`	`NUMBER`		Session ID of the LogMiner session associated with the capture process
`NEGATIVE_RULE_SET_NAME`	`VARCHAR2(30)`		Name of the negative rule set used by the capture process for filtering
`NEGATIVE_RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the negative rule set used by the capture process for filtering
`MAX_CHECKPOINT_SCN`	`NUMBER`		System change number (SCN) at which the last checkpoint was taken by the capture process
`REQUIRED_CHECKPOINT_SCN`	`NUMBER`		Lowest checkpoint SCN for which the capture process requires redo information
`LOGFILE_ASSIGNMENT`	`VARCHAR2(8)`		Logfile assignment type for the capture process: · `IMPLICIT` · `EXPLICIT`
`STATUS_CHANGE_TIME`	`DATE`		Time that the STATUS of the capture process was changed
`ERROR_NUMBER`	`NUMBER`		Error number if the capture process was aborted
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Error message if the capture process was aborted
`VERSION`	`VARCHAR2(64)`		Version number of the capture process
`CAPTURE_TYPE`	`VARCHAR2(10)`		Type of the capture process: · `DOWNSTREAM` · `LOCAL`
`LAST_ENQUEUED_SCN`	`NUMBER`		Last enqueued system change number (SCN)
`CHECKPOINT_RETENTION_TIME`	`NUMBER`		Checkpoint retention time Note: When the checkpoint retention time for a capture process is set to `INFINITE`, then the value displayed in this column is 4294967295.

Note:

1. DBMS_CAPTURE_ADM provides subprograms for starting, stopping, and configuring a capture process.

2. A capture process is an optional Oracle background process that reads the database redo log to capture DML and DDL changes made to database objects. When a capture process is configured to capture changes from a redo log, the database where the changes were generated is called the source database.