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

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 - 09:48:08 CDT