Hi Paul, Thanks for correcting me. But I forget to speicify that the Professional Windows with NTFS File System dont have file system buffer cache. Correct me if I am wrong. Regards, Paul Drake <bdbafh@xxxxxxxxx> wrote: On 6/23/05, Sunil Bhola wrote: > Hi Gonen, > > Direct I/O is depends on the operating system, you are using. Like in > UNIX/LUINUX/SOLARIS, you can use Direct I/O or File System's Buffer Cache. > In Windows there is nothing like O/S Buffer Cache. So you cannot use it. Yes > you can use Direct I/O in UNIX/LINUX/SOLARIS, for this you need to modify > the file system buffer cache. > > In the Windows it uses DIRECT I/O, means the blocks are read directly from > the disk and passes to the application that is required this. > > So when you are creating a Database in Windows you can use any block size. > But in UNIX/LINUX/SOLARIS you have to consider your FILE SYSTEM BUFFER > CACHE. Say your o/s file system buffer cache is 4k, then there is no use to > define the block size of 8k, as for any single i/o the o/s has to send the > request twice. > > Regards, > > Sunil Bhola > > Oracle_Expert, Moderator Sunil, Where did you get the idea that MS win32 operating systems had no filesystem buffer cache? (It is reccommended to turn this functionality off for running Oracle, but if exists by default). Paul http://www.microsoft.com/technet/prodtechnol/windows2000serv/maintain/optimize/wperfch7.mspx -- http://www.freelists.org/webpage/oracle-l --------------------------------- Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone.