SID

NUMBER

Session identifier of the LCR producer process

SERIAL#

NUMBER

Session serial number of the LCR producer process

RU_ID

NUMBER

Replication unit (RU) identifier

STARTUP_TIME

DATE

LCR producer process start time

STATE

VARCHAR2(33)

State of the LCR producer:

• ACTIVE

• BROWSING LCR

• DEQUEUING LCR

• ENQUEUING LCR

• INITIALIZING

• WAITING FOR MEMORY

• WAITING ON EMPTY INBOUND QUEUE

• WAITING ON SUBSCRIBERS TO DEQUEUE

STATE_CHANGED_TIME

DATE

Time at which the LCR producer state last changed

OUTBOUND_QUEUE_SIZE

NUMBER

Outbound queue size

TOTAL_AVAILABLE_LCRS_IN_OUTBOUND_QUEUE

NUMBER

Total number of LCRs available in the outbound queue

NEXT_LOG_INDEX

NUMBER

Next LCR log index

TOTAL_LCRS_DEQUEUED

NUMBER

Total number of LCRs dequeued from the foreground queue

LAST_DEQUEUED_LCR_LOG_INDEX

NUMBER

Last dequeued LCR log index

TOTAL_LCRS_ENQUEUED

NUMBER

Total number of LCRs enqueued into the outbound queue

LAST_ENQUEUED_TIME

DATE

Last LCR enqueued time

LAST_ENQUEUED_LCR_TIME

DATE

Creation time of the last LCR enqueued

LAST_ENQUEUED_LCR_LOG_INDEX

NUMBER

Last enqueued LCR log index

SPID

VARCHAR2(12)

OS process identifier

DB_ID

NUMBER

Database identifier

FLWCTRL_PEERS

VARCHAR2(64)

Flow control state

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