V$HANG_SESSION_INFO
displays information about sessions involved in hangs described by V$HANG_INFO
. Each row with the same HANG_ID
describes a session that is in the hang wait chain described by the row with the same HANG_ID
in V$HANG_INFO
. This session is blocked by the victim or final blocker of that hang.
Column | Datatype | Description |
---|---|---|
|
|
A number identifying the hang including this session. This column can be used to join |
|
|
Instance number of the instance on which this session resides |
|
|
Oracle session ID of this session |
|
|
Oracle session serial number of this session |
|
|
Operating system process ID of this session |
|
|
|
|
|
|
|
|
Name of the victim or final blocker process |
|
|
Resource or event for which this session is waiting; set to |
|
|
Session's Oracle Database Quality of Service (QoS) Management Performance Class rank See Oracle Database Quality of Service Management User's Guide for more information about Oracle Database QoS Management. |
|
|
Session's Oracle Database Quality of Service (QoS) Management Performance Class In-Trouble Threshold |
|
|
Session's Oracle Database Quality of Service (QoS) Management Performance Class Root Termination allowed Threshold |
|
|
Session's Oracle Database Quality of Service (QoS) Management Performance Class Key |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: