10.44 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
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

Note:

This view is available starting with Oracle Database 23ai.