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: Urgent: DB very slow after upgrade to v817

Re: Urgent: DB very slow after upgrade to v817

From: António Manuel Correia <manel.marias_at_netc.pt>
Date: Tue, 5 Dec 2000 23:32:32 -0000
Message-ID: <3a2d7a3f@212.18.160.197>

did you altered init.ora parameters ? From Oracle 8 the "execution plan" depends on choose/cost/rules definition in init.ora.

Did you analyze your tables ?

"Default" <sswan_at_hongkong.com.NOSPAM> wrote in message news:90iufd$kjf1_at_imsp212.netvigator.com...
> We have just upgraded DB from v732 to v817 and found that all SQLs
> requiring table scan run extremely slow. Then we found in bstat/estat
> reports that the disk read time per IO operation is 10 times slower than
> that of the previous v732.
>
> Does anybody known what's wrong? Our DB runs in Solaris 2.6 with
> VxVM. Nothing changed except DB upgrade.
>
> Thanks.
>
>
>
Received on Tue Dec 05 2000 - 17:32:32 CST

Original text of this message

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