SID

NUMBER

Session identifier of the network sender process

SERIAL#

NUMBER

Session serial number of the network sender process

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