Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 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 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