Oracle 视图 DBA_ADVISOR_FDG_BREAKDOWN 官方解释，作用，如何使用详细说明
本站中文解释
表
DBA_ADVISOR_FDG_BREAKDOWN表是Oracle数据库中的一个视图，它提供了显示SQL视图展示运行时分析细分数据的功能。它显示了各种存储和应用程序服务器操作和资源使用的趋势明细以及报表和设计实时计划的指导信息。
使用DBA_ADVISOR_FDG_BREAKDOWN表通常可以帮助数据库管理员分析数据库活动，以便更有效地管理其资源和表空间。使用该表还可以找出对于应用程序的设计影响或低效资源使用的代码段，并且可以改善SQL代码，以最大限度地提高数据库性能。
要使用DBA_ADVISOR_FDG_BREAKDOWN视图，需要先确保正确启用了视图展示SQL视图资源监控功能。此外，使用SQL视图时，还需要正确授予对此视图的正确访问权限。
官方英文解释
DBA_ADVISOR_FDG_BREAKDOWN describes the contribution from the different instances to the findings for each ADDM task.
This view is populated only with ADDM tasks that are analyzing multiple instances (that is, the ACTUAL_ANALYSIS column in the task’s row in DBA_ADDM_TASKS is set to DATABASE or PARTIAL).
Related View
USER_ADVISOR_FDG_BREAKDOWN describes the contribution from the different instances to the findings for each ADDM task owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique identifier of the task (see |
|
|
|
|
Identifier of the finding to which this breakdown applies (see |
|
|
|
|
The number of the instance for the breakdown |
|
|
|
The database time (in microseconds) of the finding in the instance |
|
|
|
|
Percentage of the contribution of the instance to the overall finding’s impact |
|
|
|
|
The name of the task execution with which this entry (row) is associated |
See Also:
“USER_ADVISOR_FDG_BREAKDOWN”
