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:
|
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 |
PURPOSE |
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
|
