Re: Switch off WinNT cache on small Oracle7 System?

It's not going to work you still have to create a page file on NT. I also don't recommend setting your SGA size more than 50% of your phisical memory;
and page file should be at least 2.5 times your phisical memory. Less you swap safer it is,
I lost a datafile once because NT died and never wrote data to the disk from a page file (IT WAS RBS !)

+--------------------------------------------------------------------------+

| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
+--------------------------------------------------------------------------+

"Frank Rünagel" wrote:

> Hi!
>
> Makes it sense to switch off the disk-caching on an Oracle
> 7.3 Server to get more free memory for the SGA?
> The System is a 166Mhz Pentium, 64 MB Ram and Raid5 USCSI,
> max. 12 users are logged in.
> The server is exclusively used for Oracle. I have read that
> Oracle has its own caching system and bypasses write-caching
> on security reasons. So: what sense makes the WinNT-cache any
> more?
> Makes it sense to increase SGA and to set the cache to 0 to ged
> rid of swapping?
>
> Thanks in advance!
> Frank
> Frank Ruenagel
> Duesseldorf, Germany
> frank.ruenagelATneuss.netsurf.de

-- Received on Wed Apr 07 1999 - 18:34:59 CDT