| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Comparing AWR Snapshots
The below snapshot outputs were taken during 2 identical load testings
of the same API. Both tests were run against the same database and I
was told the application configs/machine from where these tests were
driven were also same. Interesting things is the results of case2 test
outperformed case1 by 30%. From looking at these snapshots, I don't
see anything suspicious other than to suspect the application.
Can anyone here to comment on these outputs. Thanks.
Case1
Snap Id Snap Time Sessions Cursors/Session Begin Snap: 3620 18-Jun-05 19:00:20 61 11.3 End Snap: 3621 18-Jun-05 19:30:07 61 11.3 Elapsed: 29.78 (mins) DB Time: 2.67 (mins)
Load Profile
Per Second Per Transaction Redo size: 2,921.96 12,705.18 Logical reads: 1,281.25 5,571.09 Block changes: 24.58 106.90 Physical reads: 0.45 1.95 Physical writes:1.44 6.27 User calls: 375.45 1,632.51 Parses: 131.26 570.75 Hard parses: 0.07 0.33 Sorts: 2.93 12.73 Logons: 0.03 0.11 Executes: 135.11 587.49 Transactions: 0.23
Top 5 Timed Events
Event Waits Time(s) Percent Total DB Time Wait Class CPU time 154 96.28 class slave wait 7 35 21.89 Other control file parallel write 1,223 28 17.36 System I/O Queue Monitor Task Wait 5 25 15.63 Other db file parallel write 1,244 25 15.31 System I/O
SQL ordered by Elapsed Time (only sql the API calls)
Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time 79 79 221,021 0.00 49.65
Case2
Snap Id Snap Time Sessions Cursors/Session Begin Snap: 8135 23-Sep-05 11:00:55 63 13.8 End Snap: 8136 23-Sep-05 11:30:42 63 13.3 Elapsed: 29.78 (mins) DB Time: 4.72 (mins)
Load Profile
Per Second Per Transaction Redo size: 2,867.09 13,342.36 Logical reads: 2,053.67 9,556.99 Block changes: 17.49 81.40 Physical reads: 0.09 0.40 Physical writes:1.21 5.65 User calls: 656.18 3,053.63 Parses: 219.80 1,022.87 Hard parses: 0.02 0.08 Sorts: 1.13 5.24 Logons: 0.03 0.13 Executes: 225.17 1,047.85 Transactions: 0.21
Top 5 Timed Events
Event Waits Time(s) Percent Total DB Time Wait Class CPU time 278 98.14 class slave wait 8 40 14.12 Other Queue Monitor Task Wait 6 30 10.59 Other control file parallel write 1,211 24 8.62 System I/O db file parallel write 1,112 21 7.36 System I/O
SQL ordered by Elapsed Time (only sql the API calls)
Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time 154 154 389,034 0.00 54.17
 |
 |