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

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

ATTR21

DATE

Attributes and identifier of the object

ATTR22

DATE

Attributes and identifier of the object

OTHER

CLOB

Other attributes and identifiers of the object

ADV_SQL_ID

VARCHAR2(13)

 

If the object type is SQL, then this column contains the SQL identifier of the SQL statement. Otherwise, the value of this column is null.

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:

"USER_ADVISOR_OBJECTS"