DBA_HIST_STREAMS_CAPTURE

DBA_HIST_STREAMS_CAPTURE displays information about each capture process. This view contains a snapshot of V$STREAMS_CAPTURE. This view is intended for use with Automatic Workload Repository (AWR).

Column	Datatype	NULL	Description
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`CAPTURE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the capture process
`STARTUP_TIME`	`DATE`	`NOT NULL`	Time that the capture process was last started
`LAG`	`NUMBER`		Delay (in seconds) between the creation and capture of the most recently captured message
`TOTAL_MESSAGES_CAPTURED`	`NUMBER`		Total changes captured since the capture process was last started
`TOTAL_MESSAGES_ENQUEUED`	`NUMBER`		Total number of messages enqueued since the capture process was last started
`ELAPSED_RULE_TIME`	`NUMBER`		Elapsed time (in hundredths of a second) evaluating rules since the capture process was last started
`ELAPSED_ENQUEUE_TIME`	`NUMBER`		Elapsed time (in hundredths of a second) enqueuing messages since the capture process was last started
`ELAPSED_REDO_WAIT_TIME`	`NUMBER`		Elapsed time (in hundredths of a second) spent by the capture process in the `WAITING FOR REDO` state
`ELAPSED_PAUSE_TIME`	`NUMBER`		Elapsed pause time
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data