[Home] [Help] [Dependency Information]
Object Name: | V_$DIAG_HM_RECOMMENDATION |
---|---|
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) | ||
RECOMMENDATION_ID | NUMBER | |||
FDG_ID | NUMBER | |||
RUN_ID | NUMBER | |||
NAME | VARCHAR2 | (33) | ||
NAME_ID | NUMBER | |||
TYPE | NUMBER | |||
FLAGS | NUMBER | |||
RANK | NUMBER | |||
CREATE_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
END_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
STATUS | NUMBER | |||
EST_REPAIR_TIME | NUMBER | |||
ACT_REPAIR_TIME | NUMBER | |||
DATA_LOSS_TIME | NUMBER | |||
MSG_GRPID | NUMBER | |||
NUM_MSG | NUMBER | |||
REPAIR_SCRIPT | VARCHAR2 | (445) |
Cut, paste (and edit) the following text to query this object:
SELECT ADDR
, INDX
, INST_ID
, CON_ID
, ADR_PATH_IDX
, ADR_HOME
, RECOMMENDATION_ID
, FDG_ID
, RUN_ID
, NAME
, NAME_ID
, TYPE
, FLAGS
, RANK
, CREATE_TIME
, END_TIME
, STATUS
, EST_REPAIR_TIME
, ACT_REPAIR_TIME
, DATA_LOSS_TIME
, MSG_GRPID
, NUM_MSG
, REPAIR_SCRIPT
FROM SYS.V_$DIAG_HM_RECOMMENDATION;
|
|
|