Reading Statspack Reoport – P1

1) Wait Events :-- Look for excessive waits and wait times and check for specific problems

2) SQL Ordered by Buffer Gets,Physical Reads and Rows Processed :-- Figure out which SQL statements to tune

3) Instance Activity statistics :-- Compare with baseline report,compute additional statistics

4) Tablespace and File I/O :-- Investigate I/O bottlenecks,identify files and tablespaces with heavy I/O

5) Buffer Pool :-- Identify buffer pool with high I/O

6) Buffer wait statistics :-- Identify buffer type with large waits

7) Enqueue Activity :- Identify the locks which are causing most waits

8) Rollback Segment statistics and Storage :-- Investigate waits for rollback segments

9) Latch Activity,Latch Sleep Breakdown ,Latch Miss Sources :-- Identify latch bottlenacks

10) Non-default init.ora -- Look for init.ora parameter definitions

Look for statspack report in this order

1) Top 5 wait events

2) Load profile

3) Instance Efficiency Hit Ratios

4) Wait Events / Wait Event Histograms

5) Latch Waits

6) Top SQL

7) Instance Activity/Time Model Stats/ O/S Stats

8) File I/O / File Read Histogram / Undo Stats

9) Memory Allocations

10) Undo