DBA_ACCHK_EVENTS_SUMMARY

DBA_ACCHK_EVENTS_SUMMARY displays summary information about events that occurred during an Application Continuity Protection Check (ACCHK) workload run.

This view describes the number of times a particular type of event occurred in a session. You can use this view in conjunction with the DBA_ACCHK_STATISTICS_SUMMARY view. Join the INST_ID and CON_ID columns in this view with the INST_ID and CON_ID columns in DBA_ACCHK_STATISTICS_SUMMARY to view Application Continuity protection statistics for a particular instance.

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
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.
PROGRAM VARCHAR2(84)   Name of the operating system program that generated the trace record
MODULE VARCHAR2(64)   Name of the module that generated the trace record
ACTION VARCHAR2(64)   Name of the action that generated the trace record
SQL_ID VARCHAR2(13)   SQL identifier of the SQL statement that generated the trace record
CALL_NAME VARCHAR2(20)   Name of the user call that generated the trace record
EVENT_TYPE VARCHAR2(16)  

Event type. Possible values:

  • DISABLED - The event caused capture or replay to be disabled. Refer to the ERROR_CODE column for more information.

  • NEVER ENABLED - Neither Application Continuity nor Transparent Application Continuity was enabled for the session when the event occurred.

  • NOT ENABLING - The event describes why the database could not reenable protection after protection was disabled. Refer to the ERROR_CODE column for more information.

  • REPLAY FAILED - The event describes why the session did not fail over. This event only occurs if Application Continuity could not fail over. Refer to the ERROR_CODE column for more information.

ERROR_CODE NUMBER   If an error occurred, this column displays the error code: ORA-number. Otherwise, the value of this column is 0.
FREQUENCY NUMBER   Number of times the event occurred during the workload run
INFO VARCHAR2(256)   Information or hint associated with the event