Oracle教程 2023-02-23

Oracle 视图 DBA_ADVISOR_OBJECTS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图 DBA_ADVISOR_OBJECTS 提供有关数据库中所有被建议程序评估的对象的信息。

用途：该视图可用于检索所有的建议程序评估的对象和信息，包括相关分析所需的参数和特定信息。

使用方法：首先，可以使用 DBA_ADVISOR_OBJECTS 中的 OBJECT_TYPE 字段访问建议的类型。然后，可以使用 OBJECT_NAME 字段获取建议程序评估的对象列表。可以对每个评估对象使用此视图获取与其结果分析相关的其他信息，例如分析所需的参数，以及由分析得出的建议。

官方英文解释

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

本站中文解释

官方英文解释

相关推荐