Re: performance issues

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 06 Dec 2005 06:47:43 +0100
Message-ID: <7b9ap1piibtvn3rijq5gk6e4t7ju9i3agn@4ax.com>

On 5 Dec 2005 15:03:26 -0800, vissuyk_at_yahoo.com wrote:

>I have two IO
>controllers controlling 16 15K RPM drives. SGA = 2.7 Gigs, buffer cache
>= 1 Gig; log buffer about 10 M, a

Evidently the size of the buffer cache and the log buffer is quite ridiculous.
Reduce the log buffer to 1M and use v$db_cache_advice to reduce the size of the buffer cache. 1G is not buying you anything. Your assertion all sql statements are well tuned is hard to believe, looking at the size of the buffer cache. You may want to consider throwing away the application and start all over again.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Dec 05 2005 - 23:47:43 CST