DBA_ADVISOR_FDG_BREAKDOWN

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
TASK_ID NUMBER NOT NULL Unique identifier of the task (see DBA_ADVISOR_TASKS and DBA_ADDM_TASKS)
FINDING_ID NUMBER NOT NULL Identifier of the finding to which this breakdown applies (see DBA_ADVISOR_FINDINGS and DBA_ADDM_FINDINGS)
INSTANCE_NUMBER NUMBER NOT NULL The number of the instance for the breakdown
IMPACT NUMBER   The database time (in microseconds) of the finding in the instance
PERC_IMPACT NUMBER   Percentage of the contribution of the instance to the overall finding's impact
EXECUTION_NAME VARCHAR2(30)   The name of the task execution with which this entry (row) is associated