Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> database slow after upgrade. advice ?
Hello,
I recently upgraded my database from 7.2.3 t 7.3.3.0. The upgrade went okay,
but the users have been complaining that queries which used to run fast
prior to the upgrade run much slower !! the only change that i made before
starting the instance and opening the database (after the upgrade) was to
change the optimizer_mode to choose instead of rule.
Any suggestions anyone ?
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 24 1999 - 21:58:50 CST