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
You might want to analyze all your application tables:
Default wrote in message <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 13 2000 - 15:14:55 CST