[Home] [Help] [Dependency Information]
Object Name: | DBA_ADVISOR_OBJECTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
OBJECT_ID | NUMBER | Yes | ||
TYPE | VARCHAR2 | (64) | ||
TYPE_ID | NUMBER | Yes | ||
TASK_ID | NUMBER | Yes | ||
TASK_NAME | VARCHAR2 | (128) | ||
EXECUTION_NAME | VARCHAR2 | (128) | ||
ATTR1 | VARCHAR2 | (4000) | ||
ATTR2 | VARCHAR2 | (4000) | ||
ATTR3 | VARCHAR2 | (4000) | ||
ATTR4 | CLOB | (4000) | ||
ATTR5 | VARCHAR2 | (4000) | ||
ATTR6 | RAW | (2000) | ||
ATTR7 | NUMBER | |||
ATTR8 | NUMBER | |||
ATTR9 | NUMBER | |||
ATTR10 | NUMBER | |||
ATTR11 | NUMBER | |||
ATTR16 | VARCHAR2 | (4000) | ||
ATTR17 | VARCHAR2 | (4000) | ||
ATTR18 | VARCHAR2 | (4000) | ||
OTHER | CLOB | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, OBJECT_ID
, TYPE
, TYPE_ID
, TASK_ID
, TASK_NAME
, EXECUTION_NAME
, ATTR1
, ATTR2
, ATTR3
, ATTR4
, ATTR5
, ATTR6
, ATTR7
, ATTR8
, ATTR9
, ATTR10
, ATTR11
, ATTR16
, ATTR17
, ATTR18
, OTHER
FROM SYS.DBA_ADVISOR_OBJECTS;
|
|
|