Oracle 8.0.x on NT4 Server - FAT, NTFS or RAW? 
Author Message
 Oracle 8.0.x on NT4 Server - FAT, NTFS or RAW?
Does anyone know the pro-s and con-s (specifically performance) of selecting
FAT, NTFS or RAW disk?

Thanks
Steve



Wed, 18 Jun 1902 08:00:00 GMT
 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

Quote:

>Does anyone know the pro-s and con-s (specifically performance) of
selecting
>FAT, NTFS or RAW disk?

>Thanks
>Steve



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Oracle on NT - FAT vs NTFS.

2. Oracle on NT: NTFS or FAT?

3. Oracle on NT: NTFS or FAT

4. Logs on FAT vs NTFS??

5. Disk Format Type - FAT / NTFS

6. NTFS vs. FAT

7. Upgrade FAT to NTFS

8. NTFS vs. FAT

9. FAT vs NTFS file system

10. Fat 32 vs NTFS for SQL Backup files


 
Powered by phpBB® Forum Software