Re: Oracle slowed down

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 19 Apr 2006 09:29:24 -0700
Message-ID: <1145464160.36165@yasure.drizzle.com>

Poh Tien Lye 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

Hit ratios are meaningless nonsense. Post the explain plan from before the slow down and as it is now.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Apr 19 2006 - 11:29:24 CDT