Oracle教程

Oracle 视图 DBA_ACCHK_STATISTICS_SUMMARY 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图

Oracle视图 DBA_ACCHK_STATISTICS_SUMMARY 用于显示Oracle数据库中执行ACCESS CHECK 操作后统计结果的摘要。该视图包含以下列：

CHECK_LAST_DATE：最后一次检查的时间。

CHECK_DEFERRED：说明检查是否延迟。

TOTAL_CHECKS：说明检查的总次数。

TOTAL_EFECTS：说明总的影响次数。

TOTAL_DEFERRED：说明总的延迟次数。

它通过对 DBA_ACCHK_STATISTICS 视图的分析和计算，使用户快速地查看Access Check操作的统计信息。

使用Oracle视图 DBA_ACCHK_STATISTICS_SUMMARY 的方法：

1、查看 Access Check 操作的最后执行时间：

SELECT CHECK_LAST_DATE
FROM DBA_ACCHK_STATISTICS_SUMMARY;

2、查看 Access Check 操作总共被执行的次数：

SELECT TOTAL_CHECKS
FROM DBA_ACCHK_STATISTICS_SUMMARY;

3、查看 Access Check 操作受到的总的影响次数：

SELECT TOTAL_EFFECTS
FROM DBA_ACCHK_STATISTICS_SUMMARY;

4、查看 Access Check 操作共被延迟的次数：

SELECT TOTAL_DEFERRED
FROM DBA_ACCHK_STATISTICS_SUMMARY;

官方英文解释

DBA_ACCHK_STATISTICS_SUMMARY displays a summary of 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

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 is 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

TOTAL_REQUESTS

NUMBER

Number of requests received for this session

PROTECTED_CALLS_PERCENT

NUMBER

Percentage of user calls within requests protected by Application Continuity for failover

PROTECTED_TIME_PERCENT

NUMBER

Percentage of time spent within requests protected by Application Continuity for failover

AVG_USER_CALLS_IN_REQUESTS

NUMBER

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

AVG_PROTECTED_CALLS_IN_REQUESTS

NUMBER

Average number of user calls protected by Application Continuity within requests (between begin request and end request)

AVG_TIME_IN_REQUESTS

NUMBER

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

AVG_TIME_PROTECTED_IN_REQUESTS

NUMBER

Average 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_SUMMARY 官方解释，作用，如何使用详细说明
分享到：

相关推荐