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: Bigfoot <ext6axp_at_ups.com>
Date: Wed, 13 Dec 2000 16:14:55 -0500
Message-ID: <918osj$3ug5@biko.telecom.ups.com>

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

Original text of this message

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