5.36 DBA_ADVISOR_OBJECTS
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.
Related View
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
ATTR21
, and ATTR22
columns.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the object |
|
|
|
Identifier of the object |
|
|
|
Name of the type |
|
|
|
Type identifier number |
|
|
|
Task referencing the object |
|
|
|
Name of the task |
|
|
|
The name of the task execution with which this entry (row) is associated |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifiers that cannot be expressed in the |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Attributes and identifier of the object |
|
|
|
Other attributes and identifiers of the object |
|
|
If the object type is |
Note:
The definition of the ATTRn
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 ID -
ATTR2
contains the SQL address (in the cursor cache) -
ATTR4
contains the SQL text
See Also: