Oracle 视图 DBA_ADDM_FDG_BREAKDOWN 官方解释，作用，如何使用详细说明
本站中文解释
dba_addm_fdg_breakdown视图提供了有关Automatic Database Diagnostic Monitor动态性能视图( ADDM )分析的详细信息。它从 AWR 内部 ADDM 视图（addm_reports 和 addm_tasks）中收集以下信息：
• 分析情况的概况
• 报告生成的详细情况
• 报告的主题
• 关键性能度量标准
• 报告的汇总
• 问题的详细信息
要使用dba_addm_fdg_breakdown视图，用户必须具有SELECTobject权限。该视图通常由DBA来验证 有关ADDM 分析的细节并帮助优化性能。
官方英文解释
DBA_ADDM_FDG_BREAKDOWN describes the contribution for each finding from the different instances.
There is one row for each finding and for each instance participating in the analysis. Rows are omitted if the impact from that instance is not sufficient to register a finding in a local ADDM analysis.
Related View
USER_ADDM_FDG_BREAKDOWN describes the contribution for each finding from the different instances owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Identifies the task to which this finding belongs (see |
|
|
|
|
Identifies the finding (see |
|
|
|
|
The number of the instance contributing to the finding |
|
|
|
The database time, in microseconds, accumulated by this instance during the analysis period |
|
|
|
|
The average number of active sessions of the finding in this instance |
|
|
|
|
The percentage of contribution from this instance compared to the total impact of the finding |
See Also:
“USER_ADDM_FDG_BREAKDOWN”
