Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
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
Feedback

Go to previous page Go to next page
View PDF

ALL_APPLY

ALL_APPLY displays information about the apply processes that dequeue events 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 events (YES) or user-enqueued events (NO)

RULE_SET_NAME

VARCHAR2(30)

Rule set used by the apply process for filtering

RULE_SET_OWNER

VARCHAR2(30)

Owner of the rule set

APPLY_USER

VARCHAR2(30)

NOT NULL

User who is applying events

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(92)

Name of the user-specified DDL handler, which handles DDL logical change records

MESSAGE_HANDLER

VARCHAR2(92)

Name of the user-specified procedure that handles dequeued events other than logical change records

STATUS

VARCHAR2(8)

Status of the apply process:

  • DISABLED
  • ENABLED
  • ABORTED
See Also:

"DBA_APPLY"