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 terminated 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 NOT NULL 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

CON_UID NUMBER NOT NULL Unique ID of the container used by the session
TIMESTAMP TIMESTAMP(3) WITH TIME ZONE   Time at which the session was terminated and the statistics were reported
SESSION_ID NUMBER NOT NULL ID of the session
SERIAL# NUMBER NOT NULL 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 - TAC using database templates

  • LEVEL1 - AC or TAC using client-based restore

  • LEVEL2 - AC using database templates

  • NONE - Session state was not restored at failover

RESET_STATE VARCHAR2(16)  

Indicates the RESET_STATE service setting for the session:

  • NONE - The session is not cleaned at the end of the request.

  • LEVEL1 - The session states, which cannot be restored, are reset when a session is returned to the connection pool that uses request boundaries.

  • LOGIN - The session states are returned to the login state when a session is returned to the connection pool that uses request boundaries.
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 on user calls within requests (between begin request and end request)
TIME_PROTECTED_IN_REQUESTS NUMBER   Time (in microseconds) spent on user calls protected by Application Continuity within requests (between begin request and end request)
MAX_USER_CALLS_PER_REQUEST NUMBER   Maximum number of user calls received from the application per request (between begin request and end request)
MAX_PROT_CALLS_PER_REQUEST NUMBER   Maximum number of user calls protected by Application Continuity received from the application per request (between begin request and end request)
CON_ID_EXT NUMBER   Container ID used by the session for external recognition