AWR Report Analyse
Experts,
Can show a detail analysis for the AWR report attached, thanks!
Best Regards,
Jason
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|---|---|---|---|---|---|
| PROD | 88061726 | PROD1 | 1 | 10.2.0.4.0 | YES | hpifmdb1 |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 12802 | 03-Aug-10 00:00:11 | 271 | 124.1 |
| End Snap: | 13073 | 08-Aug-10 23:30:22 | 351 | 268.8 |
| Elapsed: | 8,610.17 (mins) | |||
| DB Time: | 29,720.99 (mins) |
Report Summary
Cache Sizes
| Begin | End | |||
|---|---|---|---|---|
| Buffer Cache: | 10,048M | 9,904M | Std Block Size: | 8K |
| Shared Pool Size: | 10,240M | 10,240M | Log Buffer: | 14,308K |
Load Profile
| Per Second | Per Transaction | |
|---|---|---|
| Redo size: | 164,480.22 | 23,094.51 |
| Logical reads: | 121,378.86 | 17,042.69 |
| Block changes: | 928.70 | 130.40 |
| Physical reads: | 409.47 | 57.49 |
| Physical writes: | 63.87 | 8.97 |
| User calls: | 403.43 | 56.64 |
| Parses: | 269.38 | 37.82 |
| Hard parses: | 1.72 | 0.24 |
| Sorts: | 264.53 | 37.14 |
| Logons: | 0.56 | 0.08 |
| Executes: | 1,736.78 | 243.86 |
| Transactions: | 7.12 |
| % Blocks changed per Read: |
3