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)`		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: `DISABLED` `ENABLED` `ABORTED`
`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
`MESSAGE_DELIVERY_MODE`	`VARCHAR2(10)`		Reserved for future use