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_ACK_RECEIVER

10.42 V$SHARD_ACK_RECEIVER

V$SHARD_ACK_RECEIVER displays information about ACK receiver processes.

Column Datatype Description

SID

NUMBER

Session identifier of the ACK receiver process

SERIAL#

NUMBER

Session serial number of the ACK receiver process

RU_ID

NUMBER

Replication unit (RU) identifier

STARTUP_TIME

DATE

ACK receiver start time

STATE

VARCHAR2(27)

State of the ACK receiver:

  • ACTIVE

  • INITIALIZING

  • POSTING USER TRANSACTION

  • WAITING FOR ACK FROM SENDER

  • WAITING FOR EOS FROM SENDER

STATE_CHANGED_TIME

DATE

Time at which the ACK receiver state last changed

ACK_SENDER_PEER_ID

NUMBER

ACK sender's database identifier of the follower

TOTAL_ACKS_RECEIVED

NUMBER

Total number of ACKs received

ACK_RECEIVED_TIME

DATE

Time at which ACK was last received

LAST_ACK_LOG_INDEX_RECEIVED

NUMBER

Last received ACK log index

SPID

VARCHAR2(12)

OS process identifier

LCR_CREATE_TIME

DATE

Commit LCR creation time

DB_ID

NUMBER

Database identifier

IO_SYNC_READ_TIME

NUMBER

Time spent on synchronous reads on Raft logs (in microseconds)

IO_ASYNC_CNT_LK_AHD_READS

NUMBER

Number of asynchronous reads on Raft logs

IO_CNT_BLK_ASYNC_READ

NUMBER

Number of times blocking was required while waiting for asynchronous look-ahead reads

IO_TIME_BLK_ASYNC_READ

NUMBER

Time spent waiting for asynchronous look-ahead reads (in microseconds)

IO_ASYNC_BLOCKS_READ

NUMBER

Total number of file blocks read asynchronously

IO_ASYNC_CACHE_HITS

NUMBER

Number of file blocks used from the look-ahead buffer

IO_BSRCH_SYNC_RDS

NUMBER

Number of times binary search was invoked to find a specific LCR

IO_CNT_CACHE_INVALID

NUMBER

Number of look-ahead read blocks that were stale

IO_BLKS_REQUIRED

NUMBER

Number of look-ahead blocks that were required

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.