DBA_APPLY displays information about all apply processes in the database. Its columns are the same as those in ALL_APPLY.
ALL_APPLY displays information about the apply processes that dequeue events from queues accessible to the current user.
| 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 events ( |
|
|
| | 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 events |
|
|
| | 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 DDL handler, which handles DDL logical change records |
|
|
| | Name of the user-specified pre-commit handler |
|
|
| | Name of the user-specified procedure that handles dequeued events other than logical change records |
|
|
| | 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 future use |
No comments:
Post a Comment