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 <[EMAIL PROTECTED]> 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
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
> 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).
__________________________________________________
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: [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).
