5.5 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

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

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 in user calls within requests (between begin request and end request)

TIME_PROTECTED_IN_REQUESTS

NUMBER

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