Oracle 视图 ALL_APPLY_PROGRESS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_APPLY_PROGRESS是Oracle的一种数据字典视图，其中包含用于特定数据泵的进度信息。它的主要用途是从视图中获取Oracle数据泵的状态、起始时间、终结时间以及其他任务相关的元数据信息。
ALL_APPLY_PROGRESS视图可以使用常见的数据库管理工具（比如SQL * Plus）以及Oracle数据库特定的SQL语句进行查询。以下是一个查询ALL_APPLY_PROGRESS视图的示例：
SELECT * FROM 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 |
|---|---|---|---|
|
|
|
|
Name of the apply process |
|
|
|
|
Global name of the source database of the changes that are applied by the apply process |
|
|
|
|
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. |
|
|
|
|
Earliest message number of the transactions currently being dequeued and applied |
|
|
|
Time at which the message with the message number displayed in the |
|
|
|
|
Time at which the message with the message number displayed in the |
|
|
|
|
Oldest transaction ID of interest. (useful for detecting long-running or large transactions) |
|
|
|
|
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. |
|
|
|
|
The global name of the source root database |
See Also:
“DBA_APPLY_PROGRESS”
