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
column.
Note:
The definition of the ATTR1 , 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
|