SID
|
NUMBER
|
Session ID of the coordinator's session
|
SERIAL#
|
NUMBER
|
Serial number of the coordinator's session
|
STATE
|
VARCHAR2(21)
|
State of the coordinator (INITIALIZING , APPLYING , SHUTTING DOWN CLEANLY , or ABORTING )
|
APPLY#
|
NUMBER
|
Apply process number. An apply process is an Oracle background process, prefixed by AP.
|
APPLY_NAME
|
VARCHAR2(30)
|
Name of the apply process
|
TOTAL_APPLIED
|
NUMBER
|
Total number of transactions applied
|
TOTAL_WAIT_DEPS
|
NUMBER
|
Number of dependency waits
|
TOTAL_WAIT_COMMITS
|
NUMBER
|
Number of waits to commit
|
TOTAL_ADMIN
|
NUMBER
|
Number of administrative requests issued
|
TOTAL_ASSIGNED
|
NUMBER
|
Number of transactions assigned
|
TOTAL_RECEIVED
|
NUMBER
|
Number of transactions received
|
TOTAL_ERRORS
|
NUMBER
|
Number of transactions which received an error on apply
|
LWM_TIME
|
DATE
|
Time low-watermark was updated
|
LWM_MESSAGE_NUMBER
|
NUMBER
|
Number of the message corresponding to the low-watermark
|
LWM_MESSAGE_CREATE_TIME
|
DATE
|
Creation time of the message corresponding to the low-watermark
|
HWM_TIME
|
DATE
|
Time high-watermark was updated
|
HWM_MESSAGE_NUMBER
|
NUMBER
|
Highest message number
|
HWM_MESSAGE_CREATE_TIME
|
DATE
|
Creation time of the highest numbered message
|
STARTUP_TIME
|
DATE
|
Time when the apply started
|
ELAPSED_SCHEDULE_TIME
|
NUMBER
|
Time elapsed scheduling messages
|