1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$SCHEDULER_IN_MEMORY_TRACE to V$ZONEMAP_USAGE_STATS
  4. V$SHARD_LCR_PERSISTER

10.49 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

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

Note:

This view is available starting with Oracle Database 23ai.