Oracle教程 2023-03-31

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

本站中文解释

Oracle视图DBA_ADDM_FINDINGS提供了ADDM（Oracle自动数据库管理器）的查询和报告结果。它是由ADDM任务产生的，用于帮助用户深入分析数据库性能和资源利用率。

DBA_ADDM_FINDINGS是一个记录视图，它保存了最新一次或所有运行中的ADDM报告运行的findings（发现）。每次ADDM运行更新此视图，因此最新的findings将被显示出来。

DBA_ADDM_FINDINGS视图包括以下列：

• ADDM_TASK_ID：ADDM任务ID
• FINDING_ID：发现ID
• FINDING_NUMBER：发现编号
• IMPACT：ADDM对发现给出的影响程度
• SIGNIFICANCE：ADDM对发现给出的重要程度
• FINDING_TYPE：ADDM发现的类型
• FINDING_NAME：发现的名称
• DESCRIPTION：解释、细节和可能的补救方案
• TIME_IDENTIFIER：时间标识符
• FACT1_RESIDUAL：可能的处理后的建议
• FACT2_RESIDUAL：可能的处理后的建议
• EXTENSION：封存的对象的名称
• EXTENSION_KEY：延伸的键
• TS_NAME：表空间名称

要使用DBA_ADDM_FINDINGS视图，必须拥有视图所属的权限。您可以使用以下查询来解析findings中的信息：

SELECT * FROM DBA_ADDM_FINDINGS;

官方英文解释

DBA_ADDM_FINDINGS displays the ADDM findings discovered by all advisors in the database.

Each row for ADDM tasks in the related DBA_ADVISOR_FINDINGS view has a corresponding row in this view.

Related View

USER_ADDM_FINDINGS displays the ADDM findings discovered by the advisors owned by the current user. Each row for ADDM tasks in the related USER_ADVISOR_FINDINGS view has a corresponding row in this view. The USER_ADDM_FINDINGS 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
`DATABASE_TIME`	`NUMBER`		The database time, in microseconds, accumulated by this finding
`ACTIVE_SESSIONS`	`NUMBER`		The average number of active sessions for the finding
`PERC_ACTIVE_SESS`	`NUMBER`		The percentage of active sessions for this finding out of the total active sessions for the task
`IS_AGGREGATE`	`CHAR(1)`		A value of `Y` means that this finding is created for global/continental ADDM as an aggregate of local ADDM findings. Otherwise, the value is `N`.
`METER_LEVEL`	`VARCHAR2(6)`		Reserved for future use
`QUERY_IS_APPROX`	`CHAR(1)`		Indicates whether the ASH SQL associated with the finding is an approximate query (`Y`) or an exact query (`N`). To get the associated query, use the `TASK_NAME` and `FINDING_ID` columns from this view and call the PL/SQL function `DBMS_ADDM.GET_ASH_QUERY(task_name, finding_id)`.

本站中文解释

官方英文解释

相关推荐