Re: Oracle slowed down

From: Bob Jones <email_at_me.not>
Date: Thu, 20 Apr 2006 03:05:42 GMT
Message-ID: <aUC1g.61766$F_3.8026@newssvr29.news.prodigy.net>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1145489802.204935_at_yasure.drizzle.com...
> Bob Jones wrote:
>> "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.
>
> High? Low? What's the difference. Hit ratios have been proven irrelevant.

Irrelevant to performance? I have not yet seen that prove. Received on Wed Apr 19 2006 - 22:05:42 CDT