Monday, June 6, 2016

How to read an AWR report

I want to show case how to read an AWR report with real world database issues.
The AWR I will display come from a production environment which I can display because there is no secret information, with the exception of the host which I will blur and SQLs which I will not show.

Because an AWR report is really long and complete, I will break it down into different posts showcasing:

  • How to generate an AWR report?
    • Using sqlplus
    • Using OEM
  • A first glance at AWR report - What to look for?
  • Identify bottlenecks
  • Memory issues
  • IO issues
  • CPU issues
All problems have many facets to them. For instance, if a server appears to be suffering from too much IO, is it because the SAN storage has reached its capacity, or is it because a new workload has caused significant increase in IO? Or is it because the system is CPU bound?

I will show how to use an AWR report to identify these issues.

No comments :

Post a Comment