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
SHARDGROUP_IDFoot 1 NUMBER ID of the shardgroup to which the ACK sender process belongs
MISC_ATTRIBUTESFoot 1 VARCHAR2(256) Formatted string containing miscellaneous process-specific attributes
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

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.