V$SHARD_APPLY_COORDINATOR

V$SHARD_APPLY_COORDINATOR displays information about apply coordinator processes.

Column Datatype Description
SID NUMBER Session identifier of the apply coordinator process
SERIAL# NUMBER Session serial number of the apply coordinator process
SHARDGROUP_IDFoot 1 NUMBER ID of the shardgroup to which the apply coordinator process belongs
MISC_ATTRIBUTESFoot 1 VARCHAR2(256) Formatted string containing miscellaneous process-specific attributes
STATE VARCHAR2(21)

Apply coordinator state:

  • ABORTING - Stopping because of an apply error

  • APPLYING - Passing transactions to apply servers

  • IDLE - Performing no work

  • INITIALIZING - Initializing

  • SHUTTING DOWN CLEANLY - Stopping without an error

APPLY# NUMBER

Apply process number

An apply process is an Oracle background process, prefixed by ap.

APPLY_NAME VARCHAR2(128) Name of the apply process
TOTAL_APPLIED NUMBER Number of transactions applied by the apply process since the apply process was last started
TOTAL_WAIT_DEPS NUMBER Number of times, since the apply process was last started, that an apply server waited to apply a logical change record (LCR) in a transaction until another apply server applied a transaction, because of a dependency between the transactions
TOTAL_WAIT_COMMITS NUMBER Number of times, since the apply process was last started, that an apply server waited to commit a transaction until another apply server committed a transaction to serialize commits
TOTAL_ADMIN NUMBER Number of administrative jobs issued since the apply process was last started
TOTAL_ASSIGNED NUMBER Number of transactions assigned to apply servers since the apply process was last started
TOTAL_RECEIVED NUMBER Number of transactions received by the coordinator process since the apply process was last started
TOTAL_IGNORED NUMBER Number of transactions that were received by the coordinator, but were ignored because they had been previously applied
TOTAL_ROLLBACKS NUMBER Number of transactions that were rolled back due to unexpected contention
TOTAL_ERRORS NUMBER Number of transactions applied by the apply process that resulted in an apply error since the apply process was last started
UNASSIGNED_COMPLETE_TXNS NUMBER Number of unassigned complete transactions
AUTO_TXN_BUFFER_SIZE NUMBER Auto-tuned transaction buffer size
LWM_TIME DATE

Time at which the LCR with the lowest log index was recorded

The creation time of the LCR with the lowest LCR log index was also recorded at this time.
LWM_LCR_LOG_INDEX NUMBER LCRs with a commit log index less than or equal to this number have definitely been applied, but some LCRs with a higher commit log index also may have been applied.
LWM_LCR_CREATE_TIME DATE Time at which the LCR corresponding to the low watermark was created
HWM_TIME DATE

Time at which the LCR with the highest log index was recorded

The creation time of the LCR with the highest LCR log index was also recorded at this time.
HWM_LCR_LOG_INDEX NUMBER No LCR with a commit log index greater than this LCR log index has been applied
HWM_LCR_CREATE_TIME DATE Time at which the LCR corresponding to the high watermark was created
STARTUP_TIME DATE Apply coordinator process start time
ELAPSED_SCHEDULE_TIME NUMBER Time elapsed (in hundredths of a second) spent scheduling transactions since the apply process was last started
ELAPSED_IDLE_TIME NUMBER Elapsed idle time (in hundredths of a second) since the apply process was last started
PROCESSED_LCR_LOG_INDEX NUMBER LCR log index currently processed by the apply coordinator
ACTIVE_SERVER_COUNT NUMBER Number of active servers
RU_ID NUMBER Replication unit (RU) 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.