7.261 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 |
---|---|---|
|
|
A number identifying the hang |
|
|
Indicates how many sessions are in the main wait chain of the hang |
|
|
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 |
|
|
Is set to |
|
|
Date and time that the hang was detected |
|
|
Time that the hang may be automatically resolved |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Contains the reason why the hang was resolved or ignored |
|
|
Instance number of the instance on which the victim or final blocker session resides |
|
|
Victim or final blocker's Oracle session ID |
|
|
Victim or final blocker's Oracle session serial number |
|
|
Victim or final blocker's operating system process ID |
|
|
|
|
|
Name of the victim or final blocker process |
|
|
Resource or event for which the victim or final blocker is waiting; set to |
|
|
Oracle Database Quality of Service (QoS) Management Performance Class rank of the victim or final blocker of the hang. |
|
|
Oracle Database QoS Management Performance Class In-Trouble Threshold of the victim or final blocker of the hang |
|
|
Oracle Database QoS Management Performance Class Root Termination allowed Threshold of the victim or final blocker of the hang |
|
|
Oracle Database QoS Management Performance Class Key of the victim or final blocker of the hang |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: