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