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 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
`CON_ID_EXT`	`NUMBER`		Container ID used by the session for external recognition
`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.
`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_PROT_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 on user calls within requests (between begin request and end request)
`AVG_TIME_PROTECTED_IN_REQUESTS`	`NUMBER`		Average 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)