Re: Combined SGA size and Total Memory

Ugh, 30% of memory would be such a waste of expensive physical Ram.

70-75% of your physical ram for Oracle is fine, assuming you've
got ample swap space and no other applications on the machine.

If you let 9i dbca default all its values, it assumes 70% as a target.
This is as good of a "rule of thumb" as any.

Todd

> 
> Hello,
> 
> A fellow DBA tells me that the total SGA size of all instances on the serve=
> r (HP, Sun) should not exceed 30% of the server's total memory. I
> could not find any documentation supporting this argument in Metalink? Is t=
> here is any such guideline? My impression was to monitor the
> paging/swap on the server before adding more memory rather than going by th=
> e rule of thumb....=20
> 
> Thanks in advance for your input.
> 
> Biju Thomas
> 
> 
> ___________________________________________________________________________=
> __________________________________
> 
> This electronic transmission and any attached files are intended solely for=
>  the person or entity to which they are addressed and may contain informati=
> on that is privileged, confidential or otherwise protected from disclosure.=
>  Any review, retransmission, dissemination or other use, including taking a=
> ny action concerning this information by anyone other than the named recipi=
> ent, is strictly prohibited. If you are not the intended recipient or have =
> received this communication in error, please immediately notify the sender =
> and destroy this communication.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: