Search This Blog

Saturday, May 5, 2012

How To Read An AWR Report ?

Prerequisites for awrreport.

Statistics level should be set to typical.
Timed statistics should also be enabled.


SQL> show parameter statistics_level 
 
NAME                                 TYPE     VALUE 
------------------------------------ -------- ------------------------------ 
statistics_level                     string   TYPICAL
Read more >>