Re: NT memory usage

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: Wed, 22 Sep 1999 08:42:12 +0100
Message-ID: <37E88854.96612B2D@totalise.co.uk>

"Daiminger, Helmut" wrote:
>
> I'm running an Oracle8 database on NT server 4.0 with 256 MB RAM. Even if
> the database uses only about 160 MB, NT starts writing to the page file.
>
> Is there any parameter that can be altered to cause NT not to start paging
> that early (i.e. with so much real memory still available)?
>
> Thanks,
> Helmut
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Hi
stopping NT swapping isn't the problem - well not directly. You need to keep the Oracle SGA in RAM (ie stop it getting paged out). in the init$ORACLCE_SID.ora file put in a line like...

lock_sga=TRUE

you NT will always have some page file activity, put for max performance you need to keep this to a minimum. Also have a look at what other processes are running and why you are running short of memory.

martin Received on Wed Sep 22 1999 - 02:42:12 CDT