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

INST_ID

NUMBER

Identifier for the instance for the session

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

TIMESTAMP

TIMESTAMP(3) WITH TIME ZONE

Time at which the session was terminated and the statistics were reported

SESSION_ID

NUMBER

ID of the session

SERIAL#

NUMBER

Serial number of the session

STAT_TYPE

VARCHAR2(32)

Type of statistic

The value of this column is always SESSION_STATISTICS.

SERVICE_NAME

VARCHAR2(64)

Service name of the session

FAILOVER_TYPE

VARCHAR2(16)

Indicates the FAILOVER_TYPE service setting for the session. Possible values:

  • AUTO – Transparent Application Continuity (TAC) was enabled for the session

  • TRANSACTION – Application Continuity (AC) was enabled for the session

  • NONE – Failover was disabled for the session

FAILOVER_RESTORE

VARCHAR2(16)

Indicates the FAILOVER_RESTORE service setting for the session. Possible values:

  • AUTO – Transparent Application Continuity

  • LEVEL1 – Application Continuity

  • NONE – Session state was not restored at failover

RESET_STATE

VARCHAR2(16)

Indicates the RESET_STATE service setting for the session. Possible values:

  • LEVEL1 – The session state was cleaned at the end of a request

  • NONE – The session state was not cleaned at the end of a request

PROGRAM

VARCHAR2(84)

Name of the operating system program

BEGIN_REQUESTS

NUMBER

Number of begin requests received for the session

END_REQUESTS

NUMBER

Number of end requests received for the session

USER_CALLS_IN_REQUESTS

NUMBER

Number of user calls received from the application within requests (between begin request and end request)

PROTECTED_CALLS_IN_REQUESTS

NUMBER

Number of user calls protected by Application Continuity (between begin request and end request)

TIME_IN_REQUESTS

NUMBER

Time in microseconds spent in user calls within requests (between begin request and end request)

TIME_PROTECTED_IN_REQUESTS

NUMBER

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.


数据运维技术 » Oracle 视图 DBA_ACCHK_STATISTICS 官方解释,作用,如何使用详细说明