eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$DIAG_DIAGV_INCIDENT

Object Details

Object Name:	V_$DIAG_DIAGV_INCIDENT
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ADDR	RAW	(8)
INDX	NUMBER
INST_ID	NUMBER
CON_ID	NUMBER
ADR_PATH_IDX	VARCHAR2	(445)
ADR_HOME	VARCHAR2	(445)
INCIDENT_ID	NUMBER
PROBLEM_ID	NUMBER
CREATE_TIME	TIMESTAMP(9) WITH TIME ZONE	(20)
CLOSE_TIME	TIMESTAMP(9) WITH TIME ZONE	(20)
STATUS	NUMBER
FLAGS	NUMBER
FLOOD_CONTROLLED	NUMBER
ERROR_FACILITY	VARCHAR2	(12)
ERROR_NUMBER	NUMBER
ERROR_ARG1	VARCHAR2	(66)
ERROR_ARG2	VARCHAR2	(66)
ERROR_ARG3	VARCHAR2	(66)
ERROR_ARG4	VARCHAR2	(66)
ERROR_ARG5	VARCHAR2	(66)
ERROR_ARG6	VARCHAR2	(66)
ERROR_ARG7	VARCHAR2	(66)
ERROR_ARG8	VARCHAR2	(66)
SIGNALLING_COMPONENT	VARCHAR2	(66)
SIGNALLING_SUBCOMPONENT	VARCHAR2	(66)
SUSPECT_COMPONENT	VARCHAR2	(66)
SUSPECT_SUBCOMPONENT	VARCHAR2	(66)
ECID	VARCHAR2	(66)
IMPACT	NUMBER
IMPACT_STR	VARCHAR2	(130)
STATUS_STR	VARCHAR2	(17)
FLOOD_CONTROL_STR	VARCHAR2	(7)
ERROR_ARG9	VARCHAR2	(66)
ERROR_ARG10	VARCHAR2	(66)
ERROR_ARG11	VARCHAR2	(66)
ERROR_ARG12	VARCHAR2	(66)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ADDR
,      INDX
,      INST_ID
,      CON_ID
,      ADR_PATH_IDX
,      ADR_HOME
,      INCIDENT_ID
,      PROBLEM_ID
,      CREATE_TIME
,      CLOSE_TIME
,      STATUS
,      FLAGS
,      FLOOD_CONTROLLED
,      ERROR_FACILITY
,      ERROR_NUMBER
,      ERROR_ARG1
,      ERROR_ARG2
,      ERROR_ARG3
,      ERROR_ARG4
,      ERROR_ARG5
,      ERROR_ARG6
,      ERROR_ARG7
,      ERROR_ARG8
,      SIGNALLING_COMPONENT
,      SIGNALLING_SUBCOMPONENT
,      SUSPECT_COMPONENT
,      SUSPECT_SUBCOMPONENT
,      ECID
,      IMPACT
,      IMPACT_STR
,      STATUS_STR
,      FLOOD_CONTROL_STR
,      ERROR_ARG9
,      ERROR_ARG10
,      ERROR_ARG11
,      ERROR_ARG12
FROM SYS.V_$DIAG_DIAGV_INCIDENT;

Dependencies

[top of page]

SYS.V_$DIAG_DIAGV_INCIDENT references the following:

SYS.V_$DIAG_DIAGV_INCIDENT is referenced by following:

PUBLIC: V$DIAG_DIAGV_INCIDENT