Re: Oracle slowed down

From: Bob Jones <email_at_me.not>
Date: Wed, 19 Apr 2006 22:33:15 GMT
Message-ID: <LUy1g.61712$F_3.40854@newssvr29.news.prodigy.net>

"Poh Tien Lye" <pohtl_at_singnet.com.sg> wrote in message news:e25jd2$anb$1_at_reader01.singnet.com.sg...
> Hi,
>
> Recently, I found that my Oracle database (8.1.7.4) on Windows NT service
> pack 6
> response time has increased significantly. I did a check and found the
> buffer chache hit ratio
> was down to less than 0.20. However, the ratio does not improve even when
> I
> increase the
> db_buffer from 17MB to 38MB. The ratio still drop to 0.20 after 8 hrs of
> operation.

Are you sure the hit ratio is calculated correctly? That is very low. How much data are you dealing with? 38MB is still too small for an average database. Received on Wed Apr 19 2006 - 17:33:15 CDT