V$STREAMS_CAPTURE

V$STREAMS_CAPTURE displays information about each capture process.

Column	Datatype	Description
`SID`	`NUMBER`	Session identifier of the capture process
`SERIAL#`	`NUMBER`	Session serial number of the capture process session
`CAPTURE#`	`NUMBER`	Capture process number. A capture process is an Oracle background process, prefixed by `cp`.
`CAPTURE_NAME`	`VARCHAR2(30)`	Name of the capture process
`LOGMINER_ID`	`NUMBER`	Session ID of the LogMiner session associated with the capture process
`STARTUP_TIME`	`DATE`	Time when the capture process was last started
`STATE`	`VARCHAR2(551)`	State of the capture process: `INITIALIZING` `CAPTURING CHANGES` `EVALUATING RULE` `ENQUEUING MESSAGE` `SHUTTING DOWN` `ABORTING` `CREATING LCR` `WAITING FOR DICTIONARY REDO` `WAITING FOR REDO` `PAUSED FOR FLOW CONTROL` `DICTIONARY INITIALIZATION` `WAITING FOR APPLY TO START` `CONNECTING TO APPLY DATABASE` `WAITING FOR PROPAGATION TO START`
`TOTAL_PREFILTER_DISCARDED`	`NUMBER`	Total number of prefiltered messages discarded
`TOTAL_PREFILTER_KEPT`	`NUMBER`	Total number of prefiltered messages kept
`TOTAL_PREFILTER_EVALUATIONS`	`NUMBER`	Total number of prefilter evaluations
`TOTAL_MESSAGES_CAPTURED`	`NUMBER`	Total number of redo entries passed by LogMiner to the capture process for detailed rule evaluation since the capture process last started. A capture process converts a redo entry into a message and performs detailed rule evaluation on the message when capture process prefiltering cannot discard the change.
`CAPTURE_TIME`	`DATE`	Time when the most recent message was captured
`CAPTURE_MESSAGE_NUMBER`	`NUMBER`	Number of the most recently captured message
`CAPTURE_MESSAGE_CREATE_TIME`	`DATE`	Creation time of the most recently captured message
`TOTAL_MESSAGES_CREATED`	`NUMBER`	Count associated with `ELAPSED_LCR_TIME` to calculate rate
`TOTAL_FULL_EVALUATIONS`	`NUMBER`	Count associated with `ELAPSED_RULE_TIME` to calculate rate
`TOTAL_MESSAGES_ENQUEUED`	`NUMBER`	Total number of messages enqueued since the capture process was last started
`ENQUEUE_TIME`	`DATE`	Time when the last message was enqueued
`ENQUEUE_MESSAGE_NUMBER`	`NUMBER`	Number of the last enqueued message
`ENQUEUE_MESSAGE_CREATE_TIME`	`DATE`	Creation time of the last enqueued message
`AVAILABLE_MESSAGE_NUMBER`	`NUMBER`	For local capture, the last redo SCN flushed to the logfiles. For downstream capture, the last SCN added to LogMiner via the archive logs.
`AVAILABLE_MESSAGE_CREATE_TIME`	`DATE`	For local capture, the time the SCN was written to the logfile. For downstream capture, the time the most recent archive log (containing the most recent SCN) was added to LogMiner.
`ELAPSED_CAPTURE_TIME`	`NUMBER`	Elapsed time (in hundredths of a second) scanning for changes in the redo log 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_LCR_TIME`	`NUMBER`	Elapsed time (in hundredths of a second) creating logical change records (LCRs) 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 flow control pause time (in hundredths of a second)
`STATE_CHANGED_TIME`	`DATE`	Time at which the state of the capture process changed
`APPLY_NAME`	`VARCHAR2(30)`	When the capture process uses combined capture and apply, the name of the apply process to which the capture process sends LCRs. If the capture process does not use combined capture and apply, then this column is not populated.
`APPLY_DBLINK`	`VARCHAR2(128)`	When the capture process uses combined capture and apply, the database link to the remote database if the apply process is at a remote database. If the capture process does not use combined capture and apply, then this column is not populated.
`APPLY_MESSAGES_SENT`	`NUMBER`	When the capture process uses combined capture and apply, the number of messages sent from the capture process to the apply process since the capture process last started. If the capture process does not use combined capture and apply, then this column is not populated.
`APPLY_BYTES_SENT`	`NUMBER`	When the capture process uses combined capture and apply, the number of bytes sent from the capture process to the apply process since the capture process last started. If the capture process does not use combined capture and apply, then this column is not populated.

Note:

The ELAPSED_CAPTURE_TIME, ELAPSED_RULE_TIME, ELAPSED_ENQUEUE_TIME, ELAPSED_LCR_TIME, and ELAPSED_REDO_WAIT_TIME columns are only populated if the TIMED_STATISTICS initialization parameter is set to true, or if the STATISTICS_LEVEL initialization parameter is set to TYPICAL or ALL.