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_NETWORK_RECEIVER

10.51 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

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

Note:

This view is available starting with Oracle Database 23ai.