DBA_ACCHK_STATISTICS

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 aborted are not included in this view.

The ACCHK_READ role allows users with no administrative privileges to query this view.

Column	Datatype	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
`TIMESTAMP`	`TIMESTAMP(3) WITH TIME ZONE`	Time at which the session was terminated and the statistics were reported
`SESSION_ID`	`NUMBER`	ID of the session
`SERIAL#`	`NUMBER`	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)

Note:

This view is available starting with Oracle Database 21c.