RE: SGA QUESTION

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Tue, 26 Jun 2001 02:08:59 -0700
Message-ID: <F001.00337D77.20010626021029@fatcity.com>

Kevin and John,

The original limit was 2GB on NT, but since service pack 3 and above this can be extended to 3GB by changing a few settings. There is also a special driver that can be obtained to allow access up to 8GB.  I have never tried this driver since I don't have any boxes with > 4GB, but I suspect that versions prior to 8i might have problems since they were released before this driver was. I

As with most memory issues on NT related to Oracle, I find the following docs invaluable:

Note: 46053.1 "Windows NT Memory Architecture Overview"
Note: 46001.1 "Oracle Database and the Windows NT memory architecture, Technical Bulletin"

I'm sure these restrictions have been removed or at least greatly enlarged in Win2K.

HTH,

• Anita
  • Kevin Kostyszyn <kevin_at_dulcian.com> wrote:
    > Hello,
    > The upper limit for a server running NT is 2gb,
    > because usually only 4gb of
    > memory can be installed. However, I believe that
    > with the patch installed,
    > enabling NT to go above 4gb of ram, it will also
    > increase the upper limit.
    > KK
    >
    > -----Original Message-----
    > Kanagaraj
    > Sent: Monday, June 25, 2001 2:18 PM
    > To: Multiple recipients of list ORACLE-L
    >
    >
    > Hi all,
    >
    > >If he has 8GB of memory, why not allocate 4GB to
    > the data
    > >buffer instead of
    >
    > I don't remember the limit, but there *is* an upper
    > limit on the amount of
    > memory that a single process can address in NT (was
    > it 2Gb?). Since the
    > architecture of Oracle on NT is a
    > single-process-multi-threaded one, and all
    > of the SGA and PGA is actually within this process
    > space, I believe that you
    > may be bumping this upper limit....
    >
    > Maybe someone with a deeper understanding of NT can
    > chip in (Anita?)
    >
    > John Kanagaraj
    

    ---

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_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 Tue Jun 26 2001 - 04:08:59 CDT