+++++++++++++++++++++++++++++++
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).

Reply via email to