Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database slow after upgrade. advice ?
Hi!
Are you sure that you don't forget analyze tables ?
sermal_at_usa.net Serge Malyshev
<srallapally_at_netscape.net> wrote in message
news:7b2hpn$t62$1_at_nnrp1.dejanews.com...
>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 Thu Feb 25 1999 - 02:18:42 CST