Oracle 视图 DBA_ACCHK_STATISTICS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_ACCHK_STATISTICS用于表示数据字典完整性检查器(DBCA)在运行完整性检查时产生的统计信息。这个视图包含以下几对列:(1)CHECKPOINT_NUMBER:完整性检查的阶段编号;(2)STEP_NUMBER:每个阶段下的步骤编号;(3)MESSAGE_NUMBER:确定步骤的消息编号;(4)MESSAGE:特定消息的描述文本;(5)EXECUTION_START:表示执行该步骤的开始时间;(6)EXECUTION_END:表示执行该步骤的结束时间。
使用视图DBA_ACCHK_STATISTICS时,要先连接上Oracle数据库,然后选择正确的用户并执行正确的SQL查询。例如,可以使用如下SQL语句查询该表:
SELECT * FROM DBA_ACCHK_STATISTICS;
官方英文解释
DBA_ACCHK_STATISTICS
displays Application Continuity protection statistics for each session that executed during an Application Continuity Protection Check (ACCHK) workload run.
ACCHK should be used on a running workload. Sessions that are aborted are not included in this view.
The ACCHK_READ
role allows users with no administrative privileges to query this view.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Identifier for the instance for the session |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
|
Time at which the session was terminated and the statistics were reported |
|
|
|
ID of the session |
|
|
|
Serial number of the session |
|
|
|
Type of statistic The value of this column is always |
|
|
|
Service name of the session |
|
|
|
Indicates the
|
|
|
|
Indicates the
|
|
|
|
Indicates the
|
|
|
|
Name of the operating system program |
|
|
|
Number of begin requests received for the session |
|
|
|
Number of end requests received for the session |
|
|
|
Number of user calls received from the application within requests (between begin request and end request) |
|
|
|
Number of user calls protected by Application Continuity (between begin request and end request) |
|
|
|
Time in microseconds spent in user calls within requests (between begin request and end request) |
|
|
|
Time in microseconds for user calls protected by Application Continuity within requests (between begin request and end request) |
Note:
This view is available starting with Oracle Database 21c.