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.

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.

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

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

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

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

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

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

Average time in microseconds for user calls protected by Application Continuity within requests (between begin request and end request)

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 DBA_ACCHK_STATISTICS_SUMMARY 官方解释，作用，如何使用详细说明