Comparing AWR Snapshots
- From: Stalin <stalinsk@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 23 Sep 2005 16:46:42 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
