ALL_APPLY

ALL_APPLY displays information about the apply processes that dequeue messages from queues accessible to the current user.

DBA_APPLY displays information about all apply processes in the database.

Column Datatype NULL Description
APPLY_NAME VARCHAR2(128) NOT NULL Name of the apply process
QUEUE_NAME VARCHAR2(128) NOT NULL Name of the queue from which the apply process dequeues
QUEUE_OWNER VARCHAR2(128) NOT NULL Owner of the queue from which the apply process dequeues
APPLY_CAPTURED VARCHAR2(3)   Indicates whether the apply process applies captured messages (YES) or user-enqueued messages (NO)
RULE_SET_NAME VARCHAR2(128)   Name of the positive rule set used by the apply process for filtering
RULE_SET_OWNER VARCHAR2(128)   Owner of the positive rule set used by the apply process for filtering
APPLY_USER VARCHAR2(128)   User who is applying messages
APPLY_DATABASE_LINK VARCHAR2(128)   Database link to which changes are applied. If NULL, then changes are applied to the local database.
APPLY_TAG RAW(2000)   Tag associated with redo log records that are generated when changes are made by the apply process
DDL_HANDLER VARCHAR2(98)   Name of the user-specified data definition language (DDL) handler, which handles DDL logical change records (LCRs)
PRECOMMIT_HANDLER VARCHAR2(98)   Name of the user-specified pre-commit handler
MESSAGE_HANDLER VARCHAR2(98)   Name of the user-specified procedure that handles dequeued messages other than logical change records (LCRs)
STATUS VARCHAR2(8)  

Status of the apply process:

  • DISABLED

  • ENABLED

  • ABORTED
MAX_APPLIED_MESSAGE_NUMBER NUMBER   System change number (SCN) corresponding to the apply process high watermark for the last time the apply process was stopped using the DBMS_APPLY_ADM.STOP_APPLY procedure with the force parameter set to false. The apply process high watermark is the SCN beyond which no messages have been applied.
NEGATIVE_RULE_SET_NAME VARCHAR2(128)   Name of the negative rule set used by the apply process for filtering
NEGATIVE_RULE_SET_OWNER VARCHAR2(128)   Owner of the negative rule set used by the apply process for filtering
STATUS_CHANGE_TIME DATE   Time that the STATUS of the apply process was changed
ERROR_NUMBER NUMBER   Error number if the apply process was terminated
ERROR_MESSAGE VARCHAR2(4000)   Error message if the apply process was terminated
MESSAGE_DELIVERY_MODE VARCHAR2(10)   Reserved for internal use
PURPOSE VARCHAR2(19)  

Purpose of the apply process:

  • GoldenGate Apply - An Oracle GoldenGate Inbound server configured by Oracle GoldenGate integrated replicat

  • XStream Out - An XStream outbound server in an XStream Out configuration

  • XStream In - An XStream inbound server in an XStream In configuration

  • AUDIT VAULT - An apply process in an audit vault configuration

  • CHANGE DATA CAPTURE - An apply process in a change data capture configuration

LCRID_VERSION NUMBER   LCR ID format currently being used

See Also: