[Home] [Help] [Dependency Information]
Object Name: | V_$HANG_INFO |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HANG_ID | NUMBER | |||
HANG_CHAIN_SESSIONS | NUMBER | |||
TOTAL_HUNG_SESSIONS | NUMBER | |||
HANG_TYPE | VARCHAR2 | (18) | ||
HANG_CREATE_TIME | VARCHAR2 | (20) | ||
HANG_RESOLVE_TIME | VARCHAR2 | (20) | ||
IGNORED_HANG | VARCHAR2 | (1) | ||
RESOLUTION_ATTEMPTED | VARCHAR2 | (1) | ||
GLOBAL_HANG | VARCHAR2 | (1) | ||
ESCALATED_HANG | VARCHAR2 | (1) | ||
RESOLUTION_STATUS | VARCHAR2 | (45) | ||
VICTIM_INSTANCE | NUMBER | |||
VICTIM_SESSION_ID | NUMBER | |||
VICTIM_SERIAL# | NUMBER | |||
VICTIM_OSPID | VARCHAR2 | (24) | ||
FATAL_BACKGROUND | VARCHAR2 | (1) | ||
PNAME | VARCHAR2 | (5) | ||
WAIT_EVENT_TEXT | VARCHAR2 | (64) | ||
VICTIM_QOS_PC_RANK | VARCHAR2 | (12) | ||
VICTIM_QOS_PC_ITT | NUMBER | |||
VICTIM_QOS_PC_RTT | NUMBER | |||
VICTIM_QOS_PC_KEY | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT HANG_ID
, HANG_CHAIN_SESSIONS
, TOTAL_HUNG_SESSIONS
, HANG_TYPE
, HANG_CREATE_TIME
, HANG_RESOLVE_TIME
, IGNORED_HANG
, RESOLUTION_ATTEMPTED
, GLOBAL_HANG
, ESCALATED_HANG
, RESOLUTION_STATUS
, VICTIM_INSTANCE
, VICTIM_SESSION_ID
, VICTIM_SERIAL#
, VICTIM_OSPID
, FATAL_BACKGROUND
, PNAME
, WAIT_EVENT_TEXT
, VICTIM_QOS_PC_RANK
, VICTIM_QOS_PC_ITT
, VICTIM_QOS_PC_RTT
, VICTIM_QOS_PC_KEY
, CON_ID
FROM SYS.V_$HANG_INFO;
|
|
|