Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance on Oracle9i - 9.2.0.7

Re: Poor Performance on Oracle9i - 9.2.0.7

From: <bdbafh_at_gmail.com>
Date: 5 May 2006 08:29:49 -0700
Message-ID: <1146842989.550790.211580@y43g2000cwc.googlegroups.com>


If all that you can determine at this point is that "performance is terrible" you should bring in a hired gun.

Did you read the database migration/upgrade guide for the 9.2 release ahead of time?
Did you test the application against a 9.2.0.7 database prior to migrating it?
How are you gathering statistics? Have you changed your use of histograms?

What part of the application is slow?
What are the most business critical parts of the application? Have you considered opening a service request with Metalink?

Perhaps you should take a step back and start here: http://www.oreilly.com/catalog/optoraclep/

After you've identified what part of the application is actually slow and is business critical, start with event 10046 tracing of that session and see what the exact problem is.

Downgrading from 9.2 to 8.1.7 is an option.

Setting the init.ora parameter optimizer_features_enable=8.1.7, but that tourniquet will be difficult to remove as its instance-wide.

If you can afford 24 CPUs of Oracle Enterprise Edition, you can likely afford a consultant.

-bdbafh Received on Fri May 05 2006 - 10:29:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US