Re: Virtual Memory Setting for Oracle on NT

Guideline : the SGA should not be bigger than one third of physical RAM. One common pitfall is the NT server is optimized as fileserver ( you can check this in the server item in the network applet of control panel). In that case one third of memory is reserved for file caching purposes. You need to make sure NT is optimized for client server operations.

Hth,

Sybrand Bakker, Oracle DBA

rockcogar <rock_cogarNOroSPAM_at_my-deja.com.invalid> wrote in message news:0a090673.76fff856_at_usw-ex0103-019.remarq.com...
> I have an Oracle 8.1.5 server on a 500 mhz Pentium III with
> 320MB of RAM that does a great deal of (slow) disk thrashing on
> most any query.
>
> I wonder if anybody knows where I can find the Oracle
> documentation that describes what are "the best" Virtual Memory
> Setting for Oracle on NT ?
>
> Thanks,
> Rock.
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Feb 17 2000 - 00:00:00 CST