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

Re: database slow after upgrade. advice ?

From: Serge <msl_at_office.peterstar.com>
Date: Thu, 25 Feb 1999 11:18:42 +0300
Message-ID: <7b30sk$pnv$1@news.wplus.spb.ru>


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

Original text of this message

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