Re: Oracle on NT: NTFS or FAT?

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: Fri, 01 Oct 1999 15:41:55 +0100
Message-ID: <37F4C833.13B754F3@totalise.co.uk>

Dave Waterworth wrote:
>
> I've heard that raw partitions can be up to twice as fast as either (can
> anyone confirm?). Apparently this performance increase is mostly acheived
> through bypassing the NT Cache?
>
> Jeff Hunter <jeffh_at_btitelecom.net> wrote in message
> news:37f3d84e_at_defiant.btitelecom.net...
> >
> > Which file system type is better to run Oracle 8i on?
> >
> >

Yes it can be faster, but its alot more fun to do backups/restores to. Most people run NTFS (for security), make sure the server is configured as a network application server (control panel/network/server) so you memory doesn't get used as filesystem cache and put the actual Oracle stuff on a Hardware raid 5 system for disk redunacy (if you want speed of disk I/O then you go for RAID 0+1 and carefully layoout your Oracle tablespaces/redos/archivelogs over lots of filesytems.

martin Received on Fri Oct 01 1999 - 09:41:55 CDT