V$SHARD_LCR_PERSISTER

V$SHARD_LCR_PERSISTER displays information about LCR persister processes.

This view displays one row for each LCR persister for a replication unit (RU).

Column Datatype Description
SID NUMBER Session identifier of the LCR persister process
SERIAL# NUMBER Session serial number of the LCR persister process
SHARDGROUP_IDFoot 1 NUMBER ID of the shardgroup to which the LCR persister 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 persister process start time
STATE VARCHAR2(30)

State of the LCR persister:

  • ACTIVE

  • INITIALIZING

  • READING FROM IO

  • WAITING FOR BUFFERS TO PERSIST

  • WAITING ON EMPTY QUEUE

  • WRITING TO IO
STATE_CHANGED_TIME DATE Time at which the LCR persister state last changed
PERSISTED_LOG_INDEX NUMBER Last persisted LCR log index
PERSISTED_TIMESTAMP DATE Timestamp of the last persisted LCR
IOBUF_INIT_US NUMBER Write buffer initialization time (in microseconds)
LEAD_IO_ISSUED_COUNT NUMBER Number of times I/O was issued on the leader
LEAD_IO_ISSUED_US NUMBER Time spent (in microseconds) during I/O on the leader
LEAD_IO_ISSUED_BLKS NUMBER Number of blocks written on the leader
LEAD_IO_FETCHED_COUNT NUMBER Number of times LCR persister issued fetch on the leader
LEAD_IO_FETCHED_US NUMBER Time (in microseconds) to fetch blocks
LEAD_IO_FETCHED_SUCCESS NUMBER Number of times the LCR persister actually fetched
LEAD_IO_BLOCKED_COUNT NUMBER Number of times I/O blocked on the leader
LEAD_IO_BLOCKED_US NUMBER Time (in microseconds) spent while the I/O was blocked
LEAD_IO_COMMITS_COUNT NUMBER Number of times commit processed on the leader
FOLL_IO_ISSUED_COUNT NUMBER Number of times I/O was issued on the follower
FOLL_IO_ISSUED_US NUMBER Time spent during I/O on the follower (in microseconds)
FOLL_IO_ISSUED_BLKS NUMBER Number of blocks written on the follower
FOLL_IO_COMMITS_COUNT NUMBER Number of times commit processed on the follower
SPID VARCHAR2(12) OS process identifier
DB_ID NUMBER Database identifier
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.