View the Exhibit and examine the sample Automatic Database Diagnostic Monitor (ADDM) report.
Which statement is true about the report?
A.
The sum of impacts under recommendations in Finding 2 cannot exceed 100%.
B.
It is possible that the sum of impacts under recommendations in Finding 2 can exceed 100%.
C.
The recommendations regarding “buffer busy” wait cannot appear more than once in the report.
D.
The sum of impacts of recommendation2 in Finding 1 and recommendation 2 in Finding 2
cannot exceed 100%.
http://docs.oracle.com/cd/B19306_01/server.102/b14211/diagnsis.htm
…
When a specific problem has multiple causes, the ADDM may report multiple problem and symptom findings.
In this case, the impacts of these multiple findings can contain the same portion of DB time.
Because the performance issues of findings can overlap, summing all the impacts of the reported findings can yield a number higher than 100% of DB time.
For example, if a system performs many read I/Os the ADDM might report a SQL statement responsible for 50% of DB time due to I/O activity as one finding, and an undersized buffer cache responsible for 75% of DB time as another finding.
…
it is possible the impact percentage sum can exceed 100%
B