Oracle 视图 ALL_GG_INBOUND_PROGRESS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_GG_INBOUND_PROGRESS 是Oracle数据库所特有的视图，主要用于查看GoldenGate进度信息。该视图用于查看从数据源抽取的数据的当前进度。它的具体内容包括：抽取程序的名称、目标表的名称、抽取的压缩百分比、抽取的状态、抽取进度、抽取开始时间和抽取统计信息等。
要使用ALL_GG_INBOUND_PROGRESS视图，可以执行以下语句：
SELECT * FROM ALL_GG_INBOUND_PROGRESS;
这样就可以查看关于GoldenGate进度信息的全部数据。
官方英文解释
ALL_GG_INBOUND_PROGRESS displays information about the progress made by the GoldenGate inbound servers accessible to the current user.
Related View
DBA_GG_INBOUND_PROGRESS displays information about the progress made by all GoldenGate inbound servers in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the inbound server |
|
|
|
Position of the processed low transaction |
|
|
|
|
All messages with commit position less than this value have been applied. This column should be used to view the progress of the GoldenGate apply. This column will hold an Oracle SCN numeric value in text format for an Oracle source database. For a non-Oracle source database, this column will hold the apply low position in GoldenGate CSN text format for that specific source database. |
|
|
|
|
Highest commit position of a transaction that has been applied |
|
|
|
|
Position of the spill low watermark of the transactions currently being applied |
|
|
|
|
Earliest position of the transactions currently being applied |
|
|
|
|
|
All SCN below or equal to this number have been successfully applied. This column is not applicable for GoldenGate replication since the source database may be non-Oracle. |
|
|
|
Time at which the |
|
|
|
|
Time at which the |
|
|
|
|
Database where the transaction originated |
|
|
|
|
The global name of the source root database where all transactions originated |
|
|
|
|
Log BSN value from the GoldenGate trail file |
See Also:
“DBA_GG_INBOUND_PROGRESS”
