| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Combined SGA size and Total Memory
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Biju
Sent: Wednesday, June 23, 2004 4:58 PM
To: oracle-l_at_freelists.org
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.
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.
 |
 |