Re: Oracle slowed down

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 19 Apr 2006 16:29:15 -0400
Message-ID: <nc7d4292a6v2ss12pfbt769clqtes5q62b@4ax.com>

On Thu, 20 Apr 2006 00:07:57 +0800, "Poh Tien Lye" <pohtl_at_singnet.com.sg> wrote:

>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.

>Any help is appreciated. Thank you.

If the amount of data has changed, and you're using CBO (which you should) try collecting statistics on the schema (look into dbms_stats package)

.......
We run Oracle 9.2.0.6 on RH4 AMD
we are currently looking for a DBA
remove NSPAM to email Received on Wed Apr 19 2006 - 15:29:15 CDT