Re: URGENT: Slow Performance after migration to 9.2.0.3 from 8.1.7

Alex: take your statspack report and visit www.oraperf.com.

For free, you can upload the report to them, their CGI script will analyze it to death, and you'll get some very juicy tips on where problems might lie.

Regards
HJR "Alex Vilner" <alex_at_sinoma.com> wrote in message news:22e9f6e0.0309080648.13628537_at_posting.google.com...
> Bill,
>
> I appreciate your honest remarks, and I feel they have merit. However,
> the reason why I pored several pages out for review was precisely that
> -- I have gone through them, and was not able to find anything that
> would give me a clue of where to look for problems...
>
> The delay is in the execution of the queries -- this is why there is a
> large number of reads in the traces. So I was looking for an extra
> pair of eyes to glance over these numbers to see if anything stood out
> that I did not catch... Oracle support has proven to be unable to
> suggest anything, and so I took it to the experts instead :)
>
> Any help will be greatly appreciated, and I will be glad to share any
> additional information -- or answer any questions that may lead to the
> problem resolution.
>
> Sincerely,
>
> Alex Vilner
>
> vslabs_at_onwe.co.za (Billy Verreynne) wrote in message
news:<1a75df45.0309061149.7f763efc_at_posting.google.com>...
> > alex_at_sinoma.com (Alex Vilner) wrote
> >
> > > We are having significant performance degradation (10 to 100 times) in
> > > the execution of the queries on the Oracle 9i server, after migrating
> > > the database from 8i to 9i
> > <snipped>
> >
> > Alex, it's great to see that you're doing the basics right - trying to
> > determine the cause of the performance problem by tackling the issue
> > with tools like stats pack.
> >
> > However.. do you honestly expext us to pour through several pages of
> > stats hunting the cause of your problem... when we do not now, never
> > mind has any familiarity, of the apps and systems you're running?
> > That's in my view akin to posting several pages of PL/SQL and asking
> > group member to find the bug and fix the code.
> >
> > You know you're system. You're not one of these stupid
> > Urgent!-please-help! posters. So I suggest that you go through those
> > stats yourself. Find anomolies. Determine where they come from. And
> > when you get stuck in determining why they occur, post the details
> > here.
> >
> > It's much easier to help getting stuck in technical details than to
> > pour through pages of outpuit looking for something unknown.
> >
> > IMO as always.
Received on Mon Sep 08 2003 - 15:51:05 CDT