Re: Comparing AWR Snapshots

Exactly. The difference in nu. of executions and total DB time spent in both cases made me to think there was some tweaking done at the application server layer which we have seen in the past to boost performance of the API. Now, need to figure out what changes were done in case2.

Thanks for you reply.

Regards,
Stalin

On 9/25/05, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
> 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