|
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
|
|
STARTUP_TIME
|
DATE
|
Time when the capture process was last started
|
|
STATE
|
VARCHAR2(17)
|
State of the capture process:
INITIALIZINGCAPTURING CHANGESEVALUATING RULEENQUEUING MESSAGESHUTTING DOWNCREATING LCR
|
|
TOTAL_MESSAGES_CAPTURED
|
NUMBER
|
Total changes captured since the capture process was last started
|
|
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_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
|
|
ELAPSED_CAPTURE_TIME
|
NUMBER
|
Elapsed time (in hundreths of a second) scanning for changes in the redo log since the capture process was last started
|
|
ELAPSED_RULE_TIME
|
NUMBER
|
Elapsed time (in hundreths of a second) evaluating rules since the capture process was last started
|
|
ELAPSED_ENQUEUE_TIME
|
NUMBER
|
Elapsed time (in hundreths of a second) enqueuing messages since the capture process was last started
|
|
ELAPSED_LCR_TIME
|
NUMBER
|
Elapsed time (in hundreths of a second) creating logical change records (LCRs) since the capture process was last started
|
