| 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: What are the Commonly Used SGA Sizes on VLDBs ?
Hi
There is a 4GB virtual memory limit / process in 32 bit unix systems. Oracle attaches the shared memory segments at 0x80000000 by default and grows upwards. Since the dlopen calls attaches at 0xEF000000, the limit is around 1.73 GB. But you could change the ksms.s module sgabeg variable and ask Oracle to attach at say 0x1000000 and which would give you around 3.7GB. It is pretty simple. Search metalink for the details steps. Basically, you edit the ksms.s file change the sgabeg variable value to 0x10000000 and recompile all the objects.
Limitation is because in 32 bit OS the limit is 4GB. If you want SGA
size beyound this, then you have to go to 64 bit, where the size is
virtually limitless.
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
"Usual disclaimers apply"
"Gene Sais"
<Gsais_at_co.palm-be To: Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>
ach.fl.us> cc:
Sent by: Subject: Re: What are the Commonly
Used SGA Sizes on VLDBs ?
root_at_fatcity.com
02/14/01 06:55 AM
Please respond to
ORACLE-L
+++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++
>>> VIVEK_SHARMA_at_infy.com 02/14 5:05 AM >>>
What are the Commonly Used SGA Sizes on VLDBs ? Answers below:
On SUN E6500 (4u) model , Solaris 2.6 , we are Unable to increase the SGA Beyond 1.7 GB on Oracle 7.3.4.5
-->Max size on 32 bit OS and oracle, 2.6 is 32 bit
Qs. What are the ways of increasing the SGA beyond this Limit ?
--> Upgrade your OS and Oracle to 8i
Qs. What are the Negative Implications of of RE-Creating the Oracle Exe
With
a Lowered Base Address to Allow Bigger SGA ?
--> Good luck on this one
NOTE - This may Give us a Only a Few Hundred MB . What if we Need MORE ?
Qs. Would this Limitaition be on Oracle 8i too ? It is a limitation on 32bit vs 64bit oracle and os
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infy.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: Gsais_at_co.palm-beach.fl.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Riyaj_Shamsudeen_at_i2.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Feb 14 2001 - 09:59:06 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |