SID |
NUMBER |
Session ID of the apply server's session |
SERIAL# |
NUMBER |
Serial number of the apply server's 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 |
Parallel execution server number of the apply server |
STATE |
VARCHAR2(20) |
State of the apply server:
-
IDLE - Performing no work
-
RECORD LOW-WATERMARK - Performing an administrative job that maintains information about the apply progress, which is used in the ALL_APPLY_PROGRESS and DBA_APPLY_PROGRESS data dictionary views
-
ADD PARTITION - Performing an administrative job that adds a partition that is used for recording information about in-progress transactions
-
DROP PARTITION - Performing an administrative job that drops a partition that was used to record information about in-progress transactions
-
EXECUTE TRANSACTION - Applying a transaction
-
WAIT COMMIT - Waiting to commit a transaction until all other transactions with a lower commit SCN are applied. This state is possible only if the COMMIT_SERIALIZATION apply process parameter is set to a value other than none and the PARALLELISM apply process parameter is set to a value greater than 1 .
-
WAIT DEPENDENCY - Waiting to apply a logical change record (LCR) in a transaction until another transaction, on which it has a dependency, is applied. This state is possible only if the PARALLELISM apply process parameter is set to a value greater than 1 .
-
WAIT FOR NEXT CHUNK - Waiting for the next set of logical change records (LCRs) for a large transaction
|
XIDUSN |
NUMBER |
Transaction ID undo segment number of the transaction currently being applied |
XIDSLT |
NUMBER |
Transaction ID slot number of the transaction currently being applied |
XIDSQN |
NUMBER |
Transaction ID sequence number of the transaction currently being applied |
COMMITSCN |
NUMBER |
Commit system change number (SCN) of the transaction currently being applied |
DEP_XIDUSN |
NUMBER |
Transaction ID undo segment number of a transaction on which the transaction being applied by this apply server depends |
DEP_XIDSLT |
NUMBER |
Transaction ID slot number of a transaction on which the transaction being applied by this apply server depends |
DEP_XIDSQN |
NUMBER |
Transaction ID sequence number of a transaction on which the transaction being applied by this apply server depends |
DEP_COMMITSCN |
NUMBER |
Commit system change number (SCN) of the transaction on which this apply server depends |
MESSAGE_SEQUENCE |
NUMBER |
Number of the current message being applied by the apply server. This value is reset to 1 at the beginning of each transaction. |
TOTAL_ASSIGNED |
NUMBER |
Total number of transactions assigned to the apply server since the apply process was last started |
TOTAL_ADMIN |
NUMBER |
Total number of administrative jobs done by the apply server since the apply process was last started. See the STATE information in this view for the types of administrative jobs. |
TOTAL_ROLLBACKS |
NUMBER |
Number of transactions assigned to this server which were rolled back |
TOTAL_MESSAGES_APPLIED |
NUMBER |
Total number of messages applied by this apply server since the apply process was last started |
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 at the source database of the last captured message applied. No information about user-enqueued messages is recorded in this column. |
ELAPSED_DEQUEUE_TIME |
NUMBER |
Time elapsed (in hundredths of a second) dequeuing messages since the apply process was last started |
ELAPSED_APPLY_TIME |
NUMBER |
Time elapsed (in hundredths of a second) applying messages since the apply process was last started |