1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
  4. ALL_APPLY

2.51 ALL_APPLY

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

Related View

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 aborted

ERROR_MESSAGE

VARCHAR2(4000)

Error message if the apply process was aborted

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: