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


Log Buffer Space

Log File Switch

Log File Sync

Idle Event