DBA_ADVISOR_OBJECTS

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

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		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(128)`		Name of the task
`EXECUTION_NAME`	`VARCHAR2(128)`		The name of the task execution with which this entry (row) is associated
`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
`ATTR6`	`RAW(2000)`		Attributes and identifier of the object
`ATTR7`	`NUMBER`		Attributes and identifier of the object
`ATTR8`	`NUMBER`		Attributes and identifier of the object
`ATTR9`	`NUMBER`		Attributes and identifier of the object
`ATTR10`	`NUMBER`		Attributes and identifier of the object
`ATTR11`	`NUMBER`		Attributes and identifier of the object
`ATTR16`	`VARCHAR2(4000)`		Attributes and identifier of the object
`ATTR17`	`VARCHAR2(4000)`		Attributes and identifier of the object
`ATTR18`	`VARCHAR2(4000)`		Attributes and identifier of the object
`OTHER`	`CLOB`		Other attributes and identifiers of the object

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