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 may also 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) |
|
Oldest transaction ID of interest. (useful for detecting long-running or large transactions) |
SPILL_MESSAGE_NUMBER |
NUMBER |
|
Spill low-watermark. Any message with a lower SCN has either been applied or spilled to disk (it will be dequeued from the Streams queue and capture will not need to resend any logical change records (LCRs) with a lower SCN). Spilled messages may not have been applied yet. |
