SID
|
NUMBER
|
Session ID of the apply server
|
SERIAL#
|
NUMBER
|
Serial number of the current session
|
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
|
SERVER_ID
|
NUMBER
|
Server number
|
STATE
|
VARCHAR2(20)
|
State of the server (IDLE , POLL SHUTDOWN , RECORD LOW-WATERMARK , ADD PARTITION , DROP PARTITION , EXECUTE TRANSACTION , WAIT COMMIT , WAIT DEPENDENCY , GET TRANSACTIONS , or WAIT FOR NEXT CHUNK )
|
XIDUSN
|
NUMBER
|
Transaction ID undo segment number currently being executed
|
XIDSLT
|
NUMBER
|
Transaction ID slot number currently being executed
|
XIDSQN
|
NUMBER
|
Transaction ID sequence number currently being executed
|
COMMITSCN
|
NUMBER
|
Commit number of the currently executing transaction
|
DEP_XIDUSN
|
NUMBER
|
Transaction ID undo segment number on which this server depends
|
DEP_XIDSLT
|
NUMBER
|
Transaction ID slot number on which this server depends
|
DEP_XIDSQN
|
NUMBER
|
Transaction ID sequence number on which this server depends
|
DEP_COMMITSCN
|
NUMBER
|
Commit number of the transaction which this server depends on
|
MESSAGE_SEQUENCE
|
NUMBER
|
Current message being applied by the server
|
TOTAL_ASSIGNED
|
NUMBER
|
Total number of transactions assigned to the server
|
TOTAL_ADMIN
|
NUMBER
|
Total number of administrative jobs done by the server
|
TOTAL_MESSAGES_APPLIED
|
NUMBER
|
Total number of messages applied by this server
|
APPLY_TIME
|
DATE
|
Time last message was applied
|
APPLIED_MESSAGE_NUMBER
|
NUMBER
|
Number of the last message applied
|
APPLIED_MESSAGE_CREATE_TIME
|
DATE
|
Creation time of the last applied message
|
ELAPSED_DEQUEUE_TIME
|
NUMBER
|
Time elapsed dequeuing messages
|
ELAPSED_APPLY_TIME
|
NUMBER
|
Time elapsed applying messages
|