Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: (memory issue)Oracle 8.1.6 on NT 4.0

Re: (memory issue)Oracle 8.1.6 on NT 4.0

From: Richard <roxl_at_ozemail.com.au>
Date: Sat, 19 Aug 2000 17:38:41 +1000
Message-ID: <kPMn5.3168$Vb.79499@ozemail.com.au>

Darrell Cooley <Darrell_Cooley_at_med.unc.edu> wrote in message news:399C26C8.BB054C19_at_med.unc.edu...
> I have just upgraded from Oracle 8.0.4 to 8.1.6.
> and I have notice a great increase in the amount
> of memory the oracle.exe is using. I currently
> have 256MB and since upgrading it is now using the
> majority of that. Is this to be expected or is
> there any tuning I can do to alleviate this.

Buffers for user data, system data, and a number of other memory related areas are are all adjustable via the initialization file (usually initSID.ora). I think you'll find that you can significantly reduce Oracle's memory requirements if you reduce these.

Regards,

Richard Gowan Received on Sat Aug 19 2000 - 02:38:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US