V$SHARD_APPLY_SERVER

V$SHARD_APPLY_SERVER displays information about apply server components.

Column Datatype Description
SID NUMBER Session identifier of the apply server component
SERIAL# NUMBER Session serial number of the apply server component
SHARDGROUP_IDFoot 1 NUMBER ID of the shardgroup to which the apply server process belongs
MISC_ATTRIBUTESFoot 1 VARCHAR2(256) Formatted string containing miscellaneous process-specific attributes
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
SERVER_ID NUMBER Parallel execution server number of the apply server
STATE VARCHAR2(20)

State of the apply server:

  • ADD PARTITION

  • DROP PARTITION

  • EXECUTE TRANSACTION

  • GET TRANSACTIONS

  • IDLE

  • INACTIVE

  • INITIALIZING

  • POLL SHUTDOWN

  • RECORD LOW-WATERMARK

  • REQUEST UA SESSION

  • ROLLBACK TRANSACTIONS

  • SPILL

  • TRANSACTION CLEANUP

  • WAIT COMMIT

  • WAIT DEPENDENCY

  • WAIT FOR CLIENT

  • WAIT FOR NEXT CHUNK

  • WAIT POST COMMIT
XIDUSN NUMBER Transaction ID undo segment number of the transaction currently being applied
XIDSLT NUMBER Transaction ID slot number of the transaction currently being applied
XIDSQN NUMBER Transaction ID undo sequence number of the transaction currently being applied
COMMIT_LOG_INDEX NUMBER Commit log index of the transaction currently being applied
DEP_XIDUSN NUMBER Transaction ID undo segment number of a transaction on which the transaction being applied by this apply server depends
DEP_XIDSLT NUMBER Transaction ID slot number of a transaction on which the transaction being applied by this apply server depends
DEP_XIDSQN NUMBER Transaction ID sequence number of a transaction on which the transaction being applied by this apply server depends
DEP_COMMIT_LOG_INDEX NUMBER Commit log index of the transaction on which this apply server depends
CURRENT_LOG_INDEX NUMBER Current LCR log index being applied by the apply server. This value is reset to 1 at the beginning of each transaction.
TOTAL_ASSIGNED NUMBER Number of transactions assigned to the apply server since the apply process was last started
TOTAL_ADMIN NUMBER Number of administrative jobs performed by the apply server since the apply process was last started. See the STATE information in this view for the types of administrative jobs.
TOTAL_ROLLBACKS NUMBER Number of transactions assigned to this server that were rolled back
TOTAL_LCRS_APPLIED NUMBER Total number of LCRs applied by this apply server since the apply process was last started
APPLY_TIME DATE Time the last LCR was applied
APPLIED_LCR_LOG_INDEX NUMBER Last applied LCR log index
APPLIED_LCR_CREATE_TIME DATE Last applied LCR create time
ELAPSED_DEQUEUE_TIME NUMBER Time elapsed (in hundredths of a second) while dequeuing LCRs
ELAPSED_APPLY_TIME NUMBER Time elapsed (in hundredths of a second) applying LCRs since the apply process was last started
TRANSACTION_ID VARCHAR2(128) ID of the transaction that the worker process is applying
TOTAL_LCRS_RETRIED NUMBER Total number of LCRs retried by this server
LCR_RETRY_ITERATION NUMBER Retry iteration for this transaction by this server
TOTAL_TXNS_RETRIED NUMBER Total number of LCRs retried by this server
TXN_RETRY_ITERATION NUMBER Retry iteration for this transaction by this server
TOTAL_TXNS_RECORDED NUMBER Total transactions recorded in error queue by this server
RU_ID NUMBER Replication unit (RU) identifier
DB_ID NUMBER Database identifier
STARTUP_TIME DATE Apply server process start time
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.