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
SHARDGROUP_IDFoot 1 NUMBER ID of the shardgroup to which the ACK receiver process belongs
MISC_ATTRIBUTESFoot 1 VARCHAR2(256) Formatted string containing miscellaneous process-specific attributes
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

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.