Re: Sun- SGA size and sgabeg question?

From: Danisment UNAL <danisment_at_yahoo.com>
Date: Wed, 07 Feb 2001 01:46:15 -0800
Message-ID: <F001.002AD5DC.20010207012525@fatcity.com>

Hi,

in theory, 32-bit word size can address max. 4Gb memory space.

I guess total 1.7GB restriction is for HP-UX (32-bit). As I know, you can have an SGA of 1 Gb max. and 1.7Gb total on HP-UX (32-bit).

Solaris and HP memory managements are different.

if you dont change sgabeg, maximum SGA size in solaris is 1.73Gb. if you change sgabeg, it's up to 3.7Gb. New additional memory is taken from where PGAs reside.

Since sgabeg is relative address in each segment, you can have many sgabegs for many segments. I guess, you may exceed 3.7Gb restriction for solaris in total.

regards...

• Riyaj_Shamsudeen_at_i2.com wrote:
  > Hi
  > We have 6GB of physical memory in one of the
  > SUN boxes (32 bit OS).
  > There are around 24 databases and using up around
  > 3.7GB of total memory. If
  > I understand correctly, cumulative size of thes SGAs
  > can not exceed 1.7GB
  > without adjusting the sgabeg address. We have 4
  > different versions of the
  > software and checked the sgabeg address in each one
  > of them and they are
  > set at default (0x80000000). Hence the cumulative
  > size can not be more than
  > 1.7GB.
  > How are we able to bring up all these database
  > ? What am I missing
  > here ?
  >
  > Thanks
  > Riyaj Shamsudeen
  >
  > --
  > 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 Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: 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).
  

  ---

---

Danisment Gazi Unal
Web: http://www.geocities.com/danisment

---

---

Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment UNAL
  INET: danisment_at_yahoo.com

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: 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 07 2001 - 03:46:15 CST