Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.x on NT4 Server - FAT, NTFS or RAW?

Re: Oracle 8.0.x on NT4 Server - FAT, NTFS or RAW?

From: David Sisk <davesisk_at_ipass.net>
Date: Sun, 29 Aug 1999 21:15:28 -0400
Message-ID: <hLky3.1261$tp2.1259@news.ipass.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US