DBA_ADVISOR_OBJECTS
displays information about the objects currently referenced by all advisors in the database. Each row in the view pertains to an object instantiation.
USER_ADVISOR_OBJECTS
displays information about the objects currently referenced by the advisors owned by the current user. This view does not display the OWNER
or OTHER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the object | |
OBJECT_ID |
NUMBER |
NOT NULL |
Identifier of the object |
TYPE |
VARCHAR2(64) |
Name of the type | |
TYPE_ID |
NUMBER |
NOT NULL |
Type identifier number |
TASK_ID |
NUMBER |
NOT NULL |
Task referencing the object |
TASK_NAME |
VARCHAR2(30) |
Name of the task | |
ATTR1 |
VARCHAR2(4000) |
Attributes and identifier of the object | |
ATTR2 |
VARCHAR2(4000) |
Attributes and identifier of the object | |
ATTR3 |
VARCHAR2(4000) |
Attributes and identifier of the object | |
ATTR4 |
CLOB |
Attributes and identifiers that cannot be expressed in the ATTR1 , ATTR2 , and ATTR3 columns |
|
ATTR5 |
VARCHAR2(4000) |
Attributes and identifier of the object | |
OTHER |
CLOB |
Other attributes and identifiers of the object |
Note:
The definition of theATTR1
, ATTR2
, ATTR3
, ATTR4
, and ATTR5
columns depends on the advisors that are using the object. For example, the SQL
object type defines the attribute columns as follows:
ATTR1 contains the SQL hash value
ATTR2
contains the SQL address (in the cursor cache)
ATTR4
contains the SQL text
See Also:
"USER_ADVISOR_OBJECTS"