Reading Statspack and AWR Reprots

                                                        .................updation in progress
 
 
Statspack Report Header

 

Statspack Load Profile

  Things to look at

          - Hard Parses
          - Executes
          - Transactions

Statspack Instance Efficiency Percentage

  Things to look at
 
    Shard Pool Parameters

       - Library Hit 
       - Execute to Parse
       - Soft Parse
 
 
Statspack Top 5 Timed Events

CPU Time
Db file sequential read
Db file scattered read


 
 
 
 
 
Wait Events

DB File Scattered Read
DB File Sequential Read
Free Buffer
Buffer Busy
Latch Free
Enqueue
Log Buffer Space
Log File Switch
Log File Sync
Idle Event


 

Comments