SID
|
NUMBER
|
Session identifier of the capture process
|
SERIAL#
|
NUMBER
|
Session serial number of the capture process
|
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 started
|
STATE
|
VARCHAR2(17)
|
State of the capture process (INITIALIZING , CAPTURING CHANGES , EVALUATING RULE , ENQUEUING MESSAGE , SHUTTING DOWN , or CREATING LCR )
|
TOTAL_MESSAGES_CAPTURED
|
NUMBER
|
Total changes captured
|
CAPTURE_TIME
|
DATE
|
Time when the most recent message was captured
|
CAPTURE_MESSAGE_NUMBER
|
NUMBER
|
Number of the most recent message
|
CAPTURE_MESSAGE_CREATE_TIME
|
DATE
|
Creation time of the most recent message
|
TOTAL_MESSAGES_ENQUEUED
|
NUMBER
|
Total number of messages enqueued
|
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 capturing changes
|
ELAPSED_RULE_TIME
|
NUMBER
|
Elapsed time evaluating rules
|
ELAPSED_ENQUEUE_TIME
|
NUMBER
|
Elapsed time enqueuing messages
|
ELAPSED_LCR_TIME
|
NUMBER
|
Elapsed time creating lcrs
|