Database Reference
In-Depth Information
You can show just differences (by default) or show all configuration values. If a review of all configuration values
is warranted, this does offer a quick review of the parameter settings and session values.
Finding
The Finding section presents each Performance Difference type, percentage of impact, and then the percentage of
impact it created for each base period (see Figure 9-57 ). Since these values can be positive for one period and negative
for another, you should note the totals for the change impact and ensure that the change impact is clearly understood
for the comparison period in case the problem was one that had escalated over multiple time periods. If escalation
did occur, the change impact percentage could be misleading, and the overall impact to the environment over a larger
period of time should be taken into consideration.
Figure 9-57. Findings for the ADDM comparison report, showing both improvement and degradation in performance
between the two periods of the comparison
For each Performance Difference, detailed information is displayed below the Details pane. As performance
regression was discovered for Top Segments by User I/O, the following findings resulted:
Individual database segments responsible for significant User I/O and Cluster waits
were found.
Impact changed from 0.04 active sessions to 0.1 active sessions, by -5%.
Resource
The Resource detail reports on differences in CPU, memory, I/O, and interconnect (if RAC is involved). This data can
be represented in either a graphical form, shown in Figure 9-58 , or in a tabular report, shown in Figure 9-59 .
Figure 9-58. Tabular representation of detail data on memory differences between two ADDM timelines in a
comparison report
 
Search WWH ::




Custom Search