7.259 V$HANG_INFO

V$HANG_INFO displays information about hangs found on the cluster.

A hang can be an open wait chain or closed wait chain (cycle or deadlock). A wait chain is a series of sessions that are blocking one another. Each row represents a hang and describes how severe the hang is. This view also includes the victim or final blocker of the hang.

Column Datatype Description

HANG_ID

NUMBER

A number identifying the hang

HANG_CHAIN_SESSIONS

NUMBER

Indicates how many sessions are in the main wait chain of the hang

TOTAL_HUNG_SESSIONS

NUMBER

Indicates how many total sessions are affected by the hang, including the main wait chain and any wait chains branching off of the main wait chain

HANG_TYPE

VARCHAR2(18)

Is set to Hang if this is an open wait chain or Deadlock if this is a cycle or closed wait chain

HANG_CREATE_TIME

VARCHAR2(20)

Date and time that the hang was detected

HANG_RESOLVE_TIME

VARCHAR2(20)

Time that the hang may be automatically resolved

IGNORED_HANG

VARCHAR2(1)

Y - Hang was ignored and will not be automatically resolved at this time

N - The hang has not yet been verified

RESOLUTION_ATTEMPTED

VARCHAR2(1)

Y - An attempt was made to resolve the hang

N - No attempt was made to resolve the hang

GLOBAL_HANG

VARCHAR2(1)

Y - The hang spans multiple nodes in the cluster

N - All of the sessions in the hang reside on a single instance

ESCALATED_HANG

VARCHAR2(1)

Y - An attempt was made to resolve the hang but was unsuccessful, and the hang is becoming more severe. Another resolution attempt will be made.

N - The first resolution attempt was successful and it was not necessary to escalate the hang to a higher resolution level.

RESOLUTION_STATUS

VARCHAR2(45)

Contains the reason why the hang was resolved or ignored

VICTIM_INSTANCE

NUMBER

Instance number of the instance on which the victim or final blocker session resides

VICTIM_SESSION_ID

NUMBER

Victim or final blocker's Oracle session ID

VICTIM_SERIAL#

NUMBER

Victim or final blocker's Oracle session serial number

VICTIM_OSPID

VARCHAR2(24)

Victim or final blocker's operating system process ID

FATAL_BACKGROUND

VARCHAR2(1)

Y - Victim or final blocker is a critical background process

N - Victim or final blocker is not a critical background process

PNAME

VARCHAR2(5)

Name of the victim or final blocker process

WAIT_EVENT_TEXT

VARCHAR2(64)

Resource or event for which the victim or final blocker is waiting; set to not in a wait if the session is not waiting on a resource

VICTIM_QOS_PC_RANK

VARCHAR2(12)

Oracle Database Quality of Service (QoS) Management Performance Class rank of the victim or final blocker of the hang.

VICTIM_QOS_PC_ITT

NUMBER

Oracle Database QoS Management Performance Class In-Trouble Threshold of the victim or final blocker of the hang

VICTIM_QOS_PC_RTT

NUMBER

Oracle Database QoS Management Performance Class Root Termination allowed Threshold of the victim or final blocker of the hang

VICTIM_QOS_PC_KEY

NUMBER

Oracle Database QoS Management Performance Class Key of the victim or final blocker of the hang

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