SID

NUMBER

Session identifier of the apply LCR reader process

SERIAL#

NUMBER

Session serial number of the apply LCR reader process

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 group

STATE

VARCHAR2(36)

State of the apply LCR reader:

• DEQUEUING LCR

• ENQUEUING LCR

• GENERATING HASH VALUES

• IDLE

• INITIALIZING

• READ ON DISK LCRS

• WAITING ON EMPTY INBOUND QUEUE

• WAITING ON FULL INBOUND QUEUE

TOTAL_LCRS_DEQUEUED

NUMBER

Total number of LCRs read

DEQUEUE_TIME

DATE

Last read LCR time

DEQUEUED_LCR_LOG_INDEX

NUMBER

Last read LCR log index

DEQUEUED_LCR_CREATE_TIME

DATE

Last read LCR create time

RU_ID

NUMBER

Replication unit (RU) identifier

DB_ID

NUMBER

Database identifier

TOTAL_ON_DISK_LCRS_READ

NUMBER

Number of LCRs read from disk

LAST_ON_DISK_LCR_LOG_INDEX

NUMBER

Last LCR log index read from disk

STARTUP_TIME

DATE

Apply LCR reader 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