Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent: DB very slow after upgrade to v817
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