Re: Urgent: DB very slow after upgrade to v817
From: (wrong string) ónio Manuel Correia <manel.marias_at_netc.pt>
Date: Tue, 5 Dec 2000 23:32:32 -0000
Message-ID: <3a2d7a3f_at_212.18.160.197>
Date: Tue, 5 Dec 2000 23:32:32 -0000
Message-ID: <3a2d7a3f_at_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 Wed Dec 06 2000 - 00:32:32 CET