Re: Limiting Oracle Memory

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Thu, 21 Jun 2001 11:33:37 -0700
Message-ID: <F001.003326CF.20010621113403@fatcity.com>

Kevin,

Note 46001.1 "Oracle Database and the Windows NT memory architecture, Technical Bulletin" is an excellent resource.

ORA_WORKINGSETMAX is set to a value in MB (complete details in the note).

Do you have QSLICE (part of the NT resource kit) or another tool that will let you view the individual threads in the oracle.exe process to see if it's all of them growing or just a rogue thread?

Have you applied the 8.1.7.1.3 patchset? There is one memory leak listed in the patchset readme.

Available on metalink - (using the flashing red link after clicking on Patches)

8.1.7.1.1: patch #1711240 (must be applied before applying 8.1.7.1.3)

8.1.7.1.3: patch #1797438

HTH,

• Anita
  • Kevin Kostyszyn <kevin_at_dulcian.com> wrote:
    > Hi all,
    > I have a procedure that seems to be bringing my
    > server to it's knees.
    > Winnt, Oracle 817 (Pipe down Ross:))
    > Anyway, what happens is a pl/sql table is placed
    > into memory and then later
    > on it will be written to the disk. However, by the
    > time the process is
    > about to get to the writing part the machine is
    > dead. The Oracle.exe
    > process is well over 700MBs and the Virtual Memory
    > is over a gig and a
    > half!! Is there anyway for me to limit this, I
    > tried using the registry
    > entry ORA_WORKINGSETMAX, however that doesn't seem
    > to work. Has anyone used
    > this setting? Are you just supposed to put a number
    > in the entry? I put
    > 600 but nothing happens. Any help would be greatly
    > appreciated.
    >
    >
    > Sincerely,
    > Kevin Kostyszyn
    > DBA
    > Dulcian, Inc
    > www.dulcian.com
    > kevin_at_dulcian.com
    >
    > --
    > Please see the official ORACLE-L FAQ:
    > http://www.orafaq.com
    > --
    > Author: Kevin Kostyszyn
    > INET: kevin_at_dulcian.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).
    

    ---

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 Thu Jun 21 2001 - 13:33:37 CDT