Re: Oracle 8i for NT work with FAT ?

Faster.. for which implication? Do you want to mix file server and database server?

NTFS work (if it not defragmented) faster with huge directories, nothing else.

If you need file size 4Gb+ , create raw file. It's fast and reliable.

Tell also, why your db srv can not live without Unix-style mounts?

> How much faster is FAT? Especially given MS stance that NTFS5 is faster
 than
> FAT.
>
> Further more if I have > 8GB file size for my partitions, which seems a
> reasonable size for current apps / disk capacities etc and it resides on
 FAT
> then the Oracle block size will be at least 16K. If the partition size is
>
> 32GB then I'll be using 32K oracle blocks. These may or may not be
 sensible
> choices , but at least using NTFS gives you choice of block size.
>
> I'd also forgotten that NTFS5 at last gives you mount points ala Unix
 making
> administration somewhat easier.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Wed Apr 25 2001 - 08:02:15 CDT