Database Reference
In-Depth Information
What happens after AWR statistics collection process
completes?
After the completion of AWR statistics collection process,
ADDM (Automatic Database Diagnostics Monitoring) feature
automatically analyzes the gathered statistics by comparing it
with the previous two snapshots taken. Such analysis can help in
finding out database problems e.g. the utilization of Oracle's
memory structure, lock contention, resource intensive SQL or
PL/SQL, CPU bottlenecks etc.
The results from ADDM are also stored in AWR.
Identifying the Problematic areas using ADDM
Enterprise Manager Database Control graphically displays the
results of the ADDM analysis under the Performance Findings
link in the “Diagnostic Summary” section. It's also available
under the “Performance” tab of main Enterprise Manger
Database Control screen as well as under the Advisor Central
link at the bottom.
Figure 11-1: Screenshot of portion of Performance page. There is “Run
ADDM Now” button under Average Active Session section.
Search WWH ::
Custom Search