V$SHARD_APPLY_LCR_READER

V$SHARD_APPLY_LCR_READER displays information about apply LCR reader processes.

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

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.