Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_ADDM_FDG_BREAKDOWN

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
TASK_ID NUMBER NOT NULL Identifies the task to which this finding belongs (see DBA_ADVISOR_TASKS)
FINDING_ID NUMBER NOT NULL Identifies the finding (see DBA_ADVISOR_FINDINGS)
INSTANCE_NUMBER NUMBER NOT NULL The number of the instance contributing to the finding
DATABASE_TIME NUMBER   The database time, in microseconds, accumulated by this instance during the analysis period
ACTIVE_SESSIONS NUMBER   The average number of active sessions of the finding in this instance
PERC_ACTIVE_SESSIONS NUMBER   The percentage of contribution from this instance compared to the total impact of the finding