Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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(30) NOT NULL Name of the apply process
QUEUE_NAME VARCHAR2(30) NOT NULL Name of the queue from which the apply process dequeues
QUEUE_OWNER VARCHAR2(30) 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(30)   Name of the positive rule set used by the apply process for filtering
RULE_SET_OWNER VARCHAR2(30)   Owner of the positive rule set used by the apply process for filtering
APPLY_USER VARCHAR2(30)   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 DDL handler, which handles DDL logical change records
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
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(30)   Name of the negative rule set used by the apply process for filtering
NEGATIVE_RULE_SET_OWNER VARCHAR2(30)   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
PURPOSEFoot 1  VARCHAR2(19)   Purpose of the apply process:
  • Streams - An apply process in an Oracle Streams configuration

  • XStream Streams - An apply process in an Oracle Streams configuration with XStream capabilities enabled by the DBMS_XSTREAM_ADM.ENABLE_GG_XSTREAM_FOR_STREAMS procedure

  • 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


Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).

See Also:

"DBA_APPLY"