RE: Comparing AWR Snapshots

Hi

>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.

To me it seams suspicious that the same test generated a so different workload. Just give a look to the number of executions of your API... in case2 there are 70-80% more calls than in case1. Other figures (e.g. logical reads, user calls and parses) are completely different as well.

If you already are on 10gR2 there is a new facility to compare two periods... With it, it's straightforward to see the differences...

HTH
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Zürich (11-Oct), Hamburg (13-Oct), München (20-Oct), Basel (25-Oct),

         Frankfurt (27-Oct), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart (13-Dec)

--
http://www.freelists.org/webpage/oracle-l