2.28 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 |
---|---|---|---|
|
|
|
Name of the apply process |
|
|
|
Name of the queue from which the apply process dequeues |
|
|
|
Owner of the queue from which the apply process dequeues |
|
|
|
Indicates whether the apply process applies captured messages ( |
|
|
|
Name of the positive rule set used by the apply process for filtering |
|
|
|
Owner of the positive rule set used by the apply process for filtering |
|
|
|
User who is applying messages |
|
|
|
Database link to which changes are applied. If NULL, then changes are applied to the local database. |
|
|
|
Tag associated with redo log records that are generated when changes are made by the apply process |
|
|
|
Name of the user-specified data definition language (DDL) handler, which handles DDL logical change records (LCRs) |
|
|
|
Name of the user-specified pre-commit handler |
|
|
|
Name of the user-specified procedure that handles dequeued messages other than logical change records (LCRs) |
|
|
|
Status of the apply process:
|
|
|
|
System change number (SCN) corresponding to the apply process high watermark for the last time the apply process was stopped using the |
|
|
|
Name of the negative rule set used by the apply process for filtering |
|
|
|
Owner of the negative rule set used by the apply process for filtering |
|
|
|
Time that the |
|
|
|
Error number if the apply process was aborted |
|
|
|
Error message if the apply process was aborted |
|
|
|
Reserved for internal use |
|
|
|
Purpose of the apply process:
|
|
|
|
LCR ID format currently being used |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_APPLY_ADM.STOP_APPLY
procedure -
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_XSTREAM_ADM.ENABLE_GG_XSTREAM_FOR_STREAMS
procedure