V$SHARD_LCR_PRODUCER

V$SHARD_LCR_PRODUCER displays information about LCR producer processes.

Column Datatype Description
SID NUMBER Session identifier of the LCR producer process
SERIAL# NUMBER Session serial number of the LCR producer process
SHARDGROUP_IDFoot 1 NUMBER ID of the shardgroup to which the LCR producer process belongs
MISC_ATTRIBUTESFoot 1 VARCHAR2(256) Formatted string containing miscellaneous process-specific attributes
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

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.3.

Note: This view is available starting with Oracle AI Database 26ai.