ALL_APPLY displays information about the apply processes that dequeue events 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(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) |
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 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(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 events other than logical change records | |
STATUS |
VARCHAR2(8) |
Status of the apply process:
|
|
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 events 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 |
See Also:
"DBA_APPLY"