V$HANG_SESSION_INFO

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
`HANG_ID`	`NUMBER`	A number identifying the hang including this session. This column can be used to join `V$HANG_INFO` with `V$HANG_SESSION_INFO`.
`INSTANCE`	`NUMBER`	Instance number of the instance on which this session resides
`SID`	`NUMBER`	Oracle session ID of this session
`SERIAL#`	`NUMBER`	Oracle session serial number of this session
`OSPID`	`VARCHAR2(24)`	Operating system process ID of this session
`FATAL_BACKGROUND`	`VARCHAR2(1)`	`Y` - Session is a critical background process `N` - Session is not a critical background process
`ROOT`	`VARCHAR2(1)`	`Y` - This session is the victim or final blocker of the hang `N` - This session is not the victim or final blocker of the hang
`PNAME`	`VARCHAR2(5)`	Name of the victim or final blocker process
`PDB_ID`	`NUMBER`	Oracle session’s container ID or PDB ID
`WAIT_EVENT_TEXT`	`VARCHAR2(64)`	Resource or event for which this session is waiting; set to `not` `in` `a` `wait` if the session is not waiting on a resource
`WAIT_TIME`	`NUMBER`	Time spent in wait for this session (in seconds). If the value of `WAIT_EVENT_TEXT` is `not` `in` `a` `wait`, then this column returns the number of seconds since the last wait.
`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

See Also: