[Home] [Help] [Dependency Information]
Object Name: | V_$DIAG_IPS_PACKAGE |
---|---|
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) | ||
PACKAGE_ID | NUMBER | |||
FLAGS | NUMBER | |||
STATUS | NUMBER | |||
CREATION_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
LAST_SEQUENCE | NUMBER | |||
LAST_COMPLETE_SEQUENCE | NUMBER | |||
PROBLEM_ID | NUMBER | |||
NAME | VARCHAR2 | (103) | ||
DESCRIPTION | VARCHAR2 | (303) | ||
CORRELATION_LEVEL | NUMBER | |||
DRIVING_INCIDENT | NUMBER | |||
BEGIN_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
END_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
UPDATE_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
LAST_BASE_SEQUENCE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ADDR
, INDX
, INST_ID
, CON_ID
, ADR_PATH_IDX
, ADR_HOME
, PACKAGE_ID
, FLAGS
, STATUS
, CREATION_TIME
, LAST_SEQUENCE
, LAST_COMPLETE_SEQUENCE
, PROBLEM_ID
, NAME
, DESCRIPTION
, CORRELATION_LEVEL
, DRIVING_INCIDENT
, BEGIN_TIME
, END_TIME
, UPDATE_TIME
, LAST_BASE_SEQUENCE
FROM SYS.V_$DIAG_IPS_PACKAGE;
|
|
|