1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
  4. DBA_ACCHK_STATISTICS_SUMMARY

5.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 21c.