Home -> Usenet -> comp.databases.oracle -> Urgent: DB very slow after upgrade to v817

Urgent: DB very slow after upgrade to v817

From: Default <sswan_at_hongkong.com.NOSPAM>
Date: Tue, 5 Dec 2000 22:34:05 +0800
Message-ID: <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 - 15:34:05 CET












Original text of this message