Oracle教程 2023-04-02

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

Oracle视图DBA_ADVISOR_FINDINGS用于可视化各个顾问项目的查找结果，以便对分析师或数据库管理员进行必要的管理活动。主要包括：查询执行时间，查找结果，查询说明，某些可以更新查找结果或为其他查找提供指导的参数值等。使用此视图可检索了解顾问执行的结果，并直接进行实际操作。

DBA_ADVISOR_FINDINGS displays the findings discovered by all advisors in the database.

Related View

USER_ADVISOR_FINDINGS displays the findings discovered 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 task
`TASK_ID`	`NUMBER`	`NOT NULL`	Identifier of the task
`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
`FINDING_ID`	`NUMBER`	`NOT NULL`	Identifier of the finding
`FINDING_NAME`	`VARCHAR2(4000)`		Name of the finding
`TYPE`	`VARCHAR2(11)`		Type of the finding: `PROBLEM` `SYMPTOM` `ERROR` `INFORMATION`
`TYPE_ID`	`NUMBER`	`NOT NULL`	Numeric ID for the value in column `TYPE`
`PARENT`	`NUMBER`	`NOT NULL`	Identifier of the parent finding
`OBJECT_ID`	`NUMBER`		Identifier of the associated object, if any
`IMPACT_TYPE`	`VARCHAR2(4000)`		Impact of the finding on the system
`IMPACT`	`NUMBER`		Impact value
`MESSAGE`	`VARCHAR2(4000)`		Message describing the finding
`MORE_INFO`	`VARCHAR2(4000)`		Additional info associated with the finding
`FILTERED`	`VARCHAR2(1)`		A value of `Y` means that the row in the view was filtered out by a directive (or a combination of directives). A value of `N` means that the row was not filtered.
`FLAGS`	`NUMBER`		For internal use only by advisor framework clients