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 -> database slow after upgrade. advice ?

database slow after upgrade. advice ?

From: <srallapally_at_netscape.net>
Date: Thu, 25 Feb 1999 03:58:50 GMT
Message-ID: <7b2hpn$t62$1@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 Wed Feb 24 1999 - 21:58:50 CST

Original text of this message

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