V$SHARD_NETWORK_RECEIVER

V$SHARD_NETWORK_RECEIVER displays information about network receiver processes.

Column Datatype Description
SID NUMBER Session identifier of the network receiver process
SERIAL# NUMBER Session serial number of the network receiver process
SHARDGROUP_IDFoot 1 NUMBER ID of the shardgroup to which the network receiver process belongs
MISC_ATTRIBUTESFoot 1 VARCHAR2(256) Formatted string containing miscellaneous process-specific attributes
APPLY_NAME VARCHAR2(128) Name of the apply process
STARTUP_TIME DATE Network receiver start time
RU_ID NUMBER Replication unit (RU) identifier
SPILL_LWM NUMBER Highest log index of LCRs that an apply has persisted to its spilled tables
LAST_RECEIVED_LOG_INDEX NUMBER Log index of the last received LCR
TOTAL_LCRS_RECEIVED NUMBER Total number of LCRs received
TOTAL_AVAILABLE_LCRS NUMBER Total number of LCRs available in knlbm
STATE VARCHAR2(38)

State of the network receiver:

  • Enqueueing LCRs

  • Initializing

  • Receiving LCRs

  • Sending unapplied txns

  • Waiting for apply error to be resolved

  • Waiting for apply to be unsuspended

  • Waiting for apply to dequeue

  • Waiting for flush request to complete

  • Waiting for memory

  • Waiting for message from peer
SPID VARCHAR2(12) OS process identifier
LAST_RECEIVED_LCR_TIME DATE Time last LCR was received
LAST_RECEIVED_LCR_CREATE_TIME DATE Creation time of last received LCR
REMOTE_PEER_ID NUMBER Database ID of the leader of this RU
TOTAL_SKIPPED_ENQUEUE_LCRS NUMBER Total number of LCRs skipped for enqueueing to apply queue
LAST_SKIPPED_ENQUEUE_LCR_LOG_INDEX NUMBER LCR log index of the last skipped enqueue to the apply queue
DB_ID NUMBER Database identifier
TOTAL_BYTES_RECEIVED NUMBER Total number of bytes received
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.