Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.x on NT4 Server - FAT, NTFS or RAW?
In a nutshell, FAT is horribly inefficient. RAW provides a performance gain
of perhaps 5-10% on NT, but requires you to micro-manage space. IMHO, NTFS
is the best choice. There are a couple of registry entries to reduce NTFS
overhead as well below. Put these into a text files called something.reg
and whatever.reg, then simply double-click on 'em from the Oracle host.
***NOTE and DISCLAIMER***
Test these thoroughly in a test system before using in a production system.
These work fine with any 32-bit Oracle software, but verify that there is no
impact on your backup solution, other apps, etc.
This one will disable date and timestamp update on directories when a file contained in the directory is updated:
REGEDIT4 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem] "NtfsDisableLastAccessUpdate"=dword:00000001
This one disables the NTFS generation of 8.3 file names. 16-bit apps will not be able to access any file with a long filename, since it won't have an 8.3 alias.
REGEDIT4 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem] "NtfsDisable8dot3NameCreation"=dword:00000001
Regards,
--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at
http://www.ipass.net/~davesisk/oont.htm
Like original music? Listen to song samples and buy a CD at
http://www.mp3.com/disparityofcult
Steve Beswick wrote in message <7qaqs2$5ke$1_at_plutonium.btinternet.com>...
>Does anyone know the pro-s and con-s (specifically performance) of
selecting
>FAT, NTFS or RAW disk?
>
>Thanks
>Steve
>
>
Received on Sun Aug 29 1999 - 20:15:28 CDT