SID

NUMBER

Session identifier of the apply server component

SERIAL#

NUMBER

Session serial number of the apply server component

APPLY#

NUMBER

Apply process number

An apply process is an Oracle background process, prefixed by ap.

APPLY_NAME

VARCHAR2(128)

Name of the apply process

SERVER_ID

NUMBER

Parallel execution server number of the apply server

STATE

VARCHAR2(20)

State of the apply server:

• ADD PARTITION

• DROP PARTITION

• EXECUTE TRANSACTION

• GET TRANSACTIONS

• IDLE

• INACTIVE

• INITIALIZING

• POLL SHUTDOWN

• RECORD LOW-WATERMARK

• REQUEST UA SESSION

• ROLLBACK TRANSACTIONS

• SPILL

• TRANSACTION CLEANUP

• WAIT COMMIT

• WAIT DEPENDENCY

• WAIT FOR CLIENT

• WAIT FOR NEXT CHUNK

• WAIT POST COMMIT

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 undo sequence number of the transaction currently being applied

COMMIT_LOG_INDEX

NUMBER

Commit log index 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_COMMIT_LOG_INDEX

NUMBER

Commit log index of the transaction on which this apply server depends

CURRENT_LOG_INDEX

NUMBER

Current LCR log index being applied by the apply server. This value is reset to 1 at the beginning of each transaction.

TOTAL_ASSIGNED

NUMBER

Number of transactions assigned to the apply server since the apply process was last started

TOTAL_ADMIN

NUMBER

Number of administrative jobs performed 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 that were rolled back

TOTAL_LCRS_APPLIED

NUMBER

Total number of LCRs applied by this apply server since the apply process was last started

APPLY_TIME

DATE

Time the last LCR was applied

APPLIED_LCR_LOG_INDEX

NUMBER

Last applied LCR log index

APPLIED_LCR_CREATE_TIME

DATE

Last applied LCR create time

ELAPSED_DEQUEUE_TIME

NUMBER

Time elapsed (in hundredths of a second) while dequeuing LCRs

ELAPSED_APPLY_TIME

NUMBER

Time elapsed (in hundredths of a second) applying LCRs since the apply process was last started

TRANSACTION_ID

VARCHAR2(128)

ID of the transaction that the worker process is applying

TOTAL_LCRS_RETRIED

NUMBER

Total number of LCRs retried by this server

LCR_RETRY_ITERATION

NUMBER

Retry iteration for this transaction by this server

TOTAL_TXNS_RETRIED

NUMBER

Total number of LCRs retried by this server

TXN_RETRY_ITERATION

NUMBER

Retry iteration for this transaction by this server

TOTAL_TXNS_RECORDED

NUMBER

Total transactions recorded in error queue by this server

RU_ID

NUMBER

Replication unit (RU) identifier

DB_ID

NUMBER

Database identifier

STARTUP_TIME

DATE

Apply server process start time

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

• 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

• 1: This value is used for rows containing data that pertain to only the root

• n: Where n is the applicable container ID for the rows containing data