[Home] [Help] [Dependency Information]
Object Name: | V_$HANG_SESSION_INFO |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HANG_ID | NUMBER | |||
INSTANCE | NUMBER | |||
SID | NUMBER | |||
SERIAL# | NUMBER | |||
OSPID | VARCHAR2 | (24) | ||
FATAL_BACKGROUND | VARCHAR2 | (1) | ||
ROOT | VARCHAR2 | (1) | ||
PNAME | VARCHAR2 | (5) | ||
WAIT_EVENT_TEXT | VARCHAR2 | (64) | ||
QOS_PC_RANK | VARCHAR2 | (12) | ||
QOS_PC_ITT | NUMBER | |||
QOS_PC_RTT | NUMBER | |||
QOS_PC_KEY | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT HANG_ID
, INSTANCE
, SID
, SERIAL#
, OSPID
, FATAL_BACKGROUND
, ROOT
, PNAME
, WAIT_EVENT_TEXT
, QOS_PC_RANK
, QOS_PC_ITT
, QOS_PC_RTT
, QOS_PC_KEY
, CON_ID
FROM SYS.V_$HANG_SESSION_INFO;
|
|
|