RE: Combined SGA size and Total Memory
- From: Muqthar Ahmed <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 17:14:16 -0400
Thomas,
I think I read it somewhere in Oracle installation manuals that the total SGAs
of all instances should not be more than 45% of physical memory. If the server
does not have other applications but Oracle databases than you are not using
other 55% memory.
I use 50% for SGAs. During peak time (when number of users increases), the PGA
+ SGAs will not go more than 70%. I also monitor PAGING/SWAPING.
Muqthar
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Thomas Biju
Sent: Wednesday, June 23, 2004 4:58 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Combined SGA size and Total Memory
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
* * * * * * * *
*
The information contained in this E-mail message is privileged, confidential,
and may be protected from disclosure; please be aware that any other use,
printing,copying,
disclosure or dissemination of this communication may be subject to legal
restriction or sanction. If you think that you have received this E-mail
message in error, please
reply to the sender and delete it from your computer. Thank you.
----------------------------------------------------------------
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
