10.43 V$SHARD_ACK_SENDER

V$SHARD_ACK_SENDER displays information about ACK sender processes.

Column Datatype Description

SID

NUMBER

Session identifier of the ACK sender process

SERIAL#

NUMBER

Session serial number of the ACK sender process

RU_ID

NUMBER

Replication unit (RU) identifier

STARTUP_TIME

DATE

ACK sender start time

STATE

VARCHAR2(25)

State of the ACK sender:

  • ACTIVE

  • CONNECTING TO LEADER

  • INITIALIZING

  • SENDING ACK

  • WAITING FOR LCR PERSISTER

STATE_CHANGED_TIME

DATE

Time at which the ACK sender state last changed

LEADER_ID

NUMBER

Database identifier of the leader of the RU

TOTAL_ACKS_SENT

NUMBER

Total number of ACKs sent

ACK_TIME

DATE

Time at which ACK was last sent

LAST_ACK_LOG_INDEX_SENT

NUMBER

Last sent ACK log index

SPID

VARCHAR2(12)

OS process identifier

DB_ID

NUMBER

Database identifier

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.