Oracle教程

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

本站中文解释

Oracle视图DBA_ACCHK_EVENTS_SUMMARY概要统计每个数据库实例的应用程序异常检查运行的错误发生次数。

它可以帮助数据库管理员监控数据库的性能，识别和处理可能出现的异常情况。

使用方法：

要正确使用此视图，您首先需要启用Oracle数据库实例上的应用程序异常检查（ACCHK）。具体操作是：

1、连接到Database Server服务器上。

2、启用ACCHK：
SQL>EXECUTE DBMS_ACCHK.CHECK_SETUP_ENABLED;

3、重新打开数据库服务，ACCHK控件将自动启动。

4、运行查询：
select * from DBA_ACCHK_EVENTS_SUMMARY;

运行此查询将生成有关每个事件的统计信息，并可以查明事件总数和最后一次事件发生的时间。用此信息，您可以识别可能出现的数据库异常情况，并采取必要的补救措施来改善性能。

官方英文解释

DBA_ACCHK_EVENTS_SUMMARY displays summary information about events that occurred during an Application Continuity Protection Check (ACCHK) workload run.

This view describes the number of times a particular type of event occurred in a session. You can use this view in conjunction with the DBA_ACCHK_STATISTICS_SUMMARY view. Join the INST_ID and CON_ID columns in this view with the INST_ID and CON_ID columns in DBA_ACCHK_STATISTICS_SUMMARY to view Application Continuity protection statistics for a particular instance.

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

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 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 that generated the trace record

MODULE

VARCHAR2(64)

Name of the module that generated the trace record

ACTION

VARCHAR2(64)

Name of the action that generated the trace record

SQL_ID

VARCHAR2(13)

SQL identifier of the SQL statement that generated the trace record

CALL_NAME

VARCHAR2(20)

Name of the user call that generated the trace record

EVENT_TYPE

VARCHAR2(16)

Event type. Possible values:

  • DISABLED – The event caused capture or replay to be disabled. Refer to the ERROR_CODE column for more information.

  • NEVER ENABLED – Neither Application Continuity nor Transparent Application Continuity was enabled for the session when the event occurred.

  • NOT ENABLING – The event describes why the database could not reenable protection after protection was disabled. Refer to the ERROR_CODE column for more information.

  • REPLAY FAILED – The event describes why the session did not fail over. This event only occurs if Application Continuity could not fail over. Refer to the ERROR_CODE column for more information.

ERROR_CODE

NUMBER

If an error occurred, this column displays the error code: ORA-number. Otherwise, the value of this column is 0.

FREQUENCY

NUMBER

Number of times the event occurred during the workload run

Note:

This view is available starting with Oracle Database 21c.


数据运维技术 » Oracle 视图 DBA_ACCHK_EVENTS_SUMMARY 官方解释，作用，如何使用详细说明
分享到：

相关推荐