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"
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
ach.fl.us> cc:
Sent by: Subject: Re: What are the Commonly
Used SGA Sizes on VLDBs ?
[EMAIL PROTECTED]
02/14/01 06:55 AM
Please respond to
ORACLE-L
+++++++++++++++++++++++++++++++
Gene Sais
Senior Oracle DBA/Systems Admin
http://www.pbcountyclerk.com
[EMAIL PROTECTED]
561.355.6579 [phone]
561.355.2600 [fax]
+++++++++++++++++++++++++++++++
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
