Re: Size of SGA

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/06/09
Message-ID: <3940FF55.58E1@yahoo.com>#1/1

ac_sekhar_at_my-deja.com wrote:
>
> Hi all,
>
> Typically what will the size of SGA in production environment.
> I heard that its around 4GB. Is it correct? 4GB seems to be
> too much of memory.
>
> Thank you
> Chandra
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Remember that while a SGA that is too small is a performance problem, an SGA that is too big is ALSO a big problem for performance...

v$sgastat is a good place to start...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Fri Jun 09 2000 - 00:00:00 CDT