Oracle 视图 V$GG_APPLY_SERVER 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$GG_APPLY_SERVER是V$ views的一部分,可用于跟踪数据库中的Golden Gate应用程序服务器的运行状态。它显示当前正在操作的应用程序服务器的特征以及应用程序服务器可以使用的配置特征和限制。
使用此视图可以获取信息,例如应用程序服务器的状态,主机名,端口号,用户名,团队号等。可以使用它来检查和调整运行三个Golden Gate应用程序服务器的参数,以便充分利用其可用资源。
下面是如何使用V$GG_APPLY_SERVER的示例:
select * from V$GG_APPLY_SERVER;
–此查询将显示数据库中Golden Gate应用程序服务器的完整信息。
select * from V$GG_APPLY_SERVER where APPLY_NAME=’myApp’;
–此查询将仅显示名为“myApp”的应用程序服务器的完整信息。
官方英文解释
V$GG_APPLY_SERVER
displays information about each GoldenGate apply server and its activities.
An apply server receives messages from the apply coordinator for an apply process. For each message received, an apply server either applies the message or sends the message to the appropriate apply handler. An apply server is a subcomponent of an apply process used by Oracle GoldenGate Integrated Replicat.
Column | Datatype | Description |
---|---|---|
|
|
Session ID of the apply server’s session |
|
|
Serial number of the apply server’s session |
|
|
Apply process number. An apply process is an Oracle background process, prefixed by |
|
|
Name of the apply process |
|
|
Parallel execution server number of the apply server |
|
|
State of the apply server:
|
|
|
Transaction ID undo segment number of the transaction currently being applied |
|
|
Transaction ID slot number of the transaction currently being applied |
|
|
Transaction ID sequence number of the transaction currently being applied |
|
|
Commit system change number (SCN) of the transaction currently being applied |
|
|
Transaction ID undo segment number of a transaction on which the transaction being applied by this apply server depends |
|
|
Transaction ID slot number of a transaction on which the transaction being applied by this apply server depends |
|
|
Transaction ID sequence number of a transaction on which the transaction being applied by this apply server depends |
|
|
Commit system change number (SCN) of the transaction on which this apply server depends |
|
|
Number of the current message being applied by the apply server. This value is reset to |
|
|
Total number of transactions assigned to the apply server since the apply process was last started |
|
|
Total number of administrative jobs done by the apply server since the apply process was last started. See the |
|
|
Number of transactions assigned to this server which were rolled back |
|
|
Total number of messages applied by this apply server since the apply process was last started |
|
|
Time the last message was applied |
|
|
Time elapsed (in hundredths of a second) applying messages since the apply process was last started |
|
|
Commit position of the transaction. This column is populated only for an apply process that is functioning as a GoldenGate Integrated Replicat. |
|
|
Commit position of the transaction the slave depends on. This column is populated only for an apply process that is functioning as a GoldenGate inbound server. |
|
|
For inbound servers, the position of the last message applied; for outbound servers, the position of the last message sent to the XStream client application. This column is populated only for an apply process that is functioning as a GoldenGate outbound server or inbound server. |
|
|
Transaction ID that the slave is applying. This column is populated only for an apply process that is functioning as a GoldenGate inbound server. |
|
|
Transaction ID of the transaction the slave depends on. This column is populated only for an apply process that is functioning as a GoldenGate inbound server. |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
Total number of LCRs retried by this server |
|
|
Retry iteration for this transaction by this server |
|
|
Total transactions retried by this server |
|
|
Retry iteration for this transaction by this server |
|
|
Total transactions recorded in error queue by this server |
Note:
The ELAPSED_SCHEDULE_TIME
column is only populated if the TIMED_STATISTICS
initialization parameter is set to true
, or if the STATISTICS_LEVEL
initialization parameter is set to TYPICAL
or ALL
.
See Also:
-
“TIMED_STATISTICS”
-
“STATISTICS_LEVEL”