[Home] [Help] [Dependency Information]
Object Name: | V_$DIAG_VPROBLEM1 |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDR | RAW | (8) | ||
INDX | NUMBER | |||
INST_ID | NUMBER | |||
CON_ID | NUMBER | |||
ADR_PATH_IDX | VARCHAR2 | (445) | ||
ADR_HOME | VARCHAR2 | (445) | ||
PROBLEM_ID | NUMBER | |||
PROBLEM_KEY | VARCHAR2 | (552) | ||
FIRST_INCIDENT | NUMBER | |||
FIRSTINC_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
LAST_INCIDENT | NUMBER | |||
LASTINC_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
IMPACT1 | NUMBER | |||
IMPACT2 | NUMBER | |||
IMPACT3 | NUMBER | |||
IMPACT4 | NUMBER | |||
SERVICE_REQUEST | VARCHAR2 | (66) | ||
BUG_NUMBER | VARCHAR2 | (66) | ||
IMPACT_STR1 | VARCHAR2 | (130) | ||
IMPACT_STR2 | VARCHAR2 | (130) | ||
IMPACT_STR3 | VARCHAR2 | (130) | ||
IMPACT_STR4 | VARCHAR2 | (130) | ||
SOURCE | NUMBER | |||
LAST_INCIDENT_IMPACT | VARCHAR2 | (130) | ||
ADVISOR | VARCHAR2 | (34) | ||
FLOOD_CONTROLLED | NUMBER | |||
INCIDENT_CNT | NUMBER | |||
DETAIL | VARCHAR2 | (202) |
Cut, paste (and edit) the following text to query this object:
SELECT ADDR
, INDX
, INST_ID
, CON_ID
, ADR_PATH_IDX
, ADR_HOME
, PROBLEM_ID
, PROBLEM_KEY
, FIRST_INCIDENT
, FIRSTINC_TIME
, LAST_INCIDENT
, LASTINC_TIME
, IMPACT1
, IMPACT2
, IMPACT3
, IMPACT4
, SERVICE_REQUEST
, BUG_NUMBER
, IMPACT_STR1
, IMPACT_STR2
, IMPACT_STR3
, IMPACT_STR4
, SOURCE
, LAST_INCIDENT_IMPACT
, ADVISOR
, FLOOD_CONTROLLED
, INCIDENT_CNT
, DETAIL
FROM SYS.V_$DIAG_VPROBLEM1;
|
|
|