ALL_APPLY_PROGRESS

ALL_APPLY_PROGRESS displays information about the progress made by the apply processes that dequeue events from queues accessible to the current user. This view only contains information about captured events. It does not contain information about user-enqueued events.

Related View

DBA_APPLY_PROGRESS displays information about the progress made by all apply processes in the database.

Column

Datatype

NULL

Description

APPLY_NAME

VARCHAR2(30)

NOT NULL

Name of the apply process

SOURCE_DATABASE

VARCHAR2(128)

NOT NULL

Global name of the source database of the changes that are applied by the apply process

APPLIED_MESSAGE_NUMBER

NUMBER

NOT NULL

Message number up to which all transactions have definitely been applied. This value is the low-watermark for the apply process. That is, messages with a commit message number less than or equal to this message number have definitely been applied, but some messages with a higher commit message number also may have been applied.

OLDEST_MESSAGE_NUMBER

NUMBER

NOT NULL

Earliest message number of the transactions currently being dequeued and applied

APPLY_TIME

DATE

Time at which the message with the message number displayed in the APPLIED_MESSAGE_NUMBER column was applied

APPLIED_MESSAGE_CREATE_TIME

DATE

Time at which the message with the message number displayed in the APPLIED_MESSAGE_NUMBER column was created at its source database

OLDEST_TRANSACTION_ID

VARCHAR2(22)

The oldest transaction ID of interest. It is useful for detecting long-running or large transactions.