[Home] [Help] [Dependency Information]
Object Name: | V_$DIAG_ADR_CONTROL |
---|---|
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) | ||
ADRID | NUMBER | |||
SHORTP_POLICY | NUMBER | |||
LONGP_POLICY | NUMBER | |||
LAST_MOD_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
LAST_AUTOPRG_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
LAST_MANUPRG_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
ADRDIR_VERSION | NUMBER | |||
ADRSCHM_VERSION | NUMBER | |||
ADRSCHMV_SUMMARY | NUMBER | |||
ADRALERT_VERSION | NUMBER | |||
CREATE_TIME | TIMESTAMP(9) WITH TIME ZONE | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT ADDR
, INDX
, INST_ID
, CON_ID
, ADR_PATH_IDX
, ADR_HOME
, ADRID
, SHORTP_POLICY
, LONGP_POLICY
, LAST_MOD_TIME
, LAST_AUTOPRG_TIME
, LAST_MANUPRG_TIME
, ADRDIR_VERSION
, ADRSCHM_VERSION
, ADRSCHMV_SUMMARY
, ADRALERT_VERSION
, CREATE_TIME
FROM SYS.V_$DIAG_ADR_CONTROL;
|
|
|