V$SHARD_NETWORK_SENDER

V$SHARD_NETWORK_SENDER displays information about network sender processes.

Column Datatype Description
SID NUMBER Session identifier of the network sender process
SERIAL# NUMBER Session serial number of the network sender process
SHARDGROUP_IDFoot 1 NUMBER ID of the shardgroup to which the network sender process belongs
MISC_ATTRIBUTESFoot 1 VARCHAR2(256) Formatted string containing miscellaneous process-specific attributes
RU_ID NUMBER Replication unit (RU) identifier
REMOTE_PEER_ID NUMBER Remote follower’s database identifier of this RU
STARTUP_TIME DATE Network sender process start time
STATE VARCHAR2(22)

State of the network sender:

  • ACTIVE

  • BROWSING LCR

  • CONNECTING TO FOLLOWER

  • DEQUEUING LCR SENDING LCR

  • INITIALIZING

  • WAITING ON EMPTY QUEUE
STATE_CHANGED_TIME DATE Time at which the network sender state last changed
TOTAL_LCRS_SENT NUMBER Number of LCRs sent
BROWSED_TIME DATE Last browsed LCR time
LAST_BROWSED_LCR_LOG_INDEX NUMBER Last browsed LCR log index
SEND_TIME DATE Time at which last LCR was sent
LAST_SENT_LCR_LOG_INDEX NUMBER Last sent LCR log index
LAST_SENT_LCR_TIME DATE Creation time of the last sent LCR
ELAPSED_PROPAGATION_TIME NUMBER Amount of time taken to propogate LCRs (in what unit of time?)
AVAILABLE_LCRS NUMBER Number of LCRs available in outbound queue
SPID VARCHAR2(12) OS process identifier
CONNECT_ERROR_COUNT NUMBER Number of network sender connection errors
DB_ID NUMBER Database identifier
TOTAL_BYTES_SENT NUMBER Total number of bytes sent
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_REA 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.