4.6 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 release 19c, version 19.11. However, it is not created by default in Oracle Database release 19c. To create this view, you must run the DBMS_APP_CONT_ADMIN.ACCHK_VIEWS( ) procedure. See Oracle Database PL/SQL Packages and Types Reference for more information.