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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Q: does DirectIO on windows is supported on file systems ?

Re: Q: does DirectIO on windows is supported on file systems ?

From: Sunil Bhola <oraclebhola_at_yahoo.com>
Date: Thu, 23 Jun 2005 06:49:30 -0700 (PDT)
Message-ID: <20050623134930.85467.qmail@web31602.mail.mud.yahoo.com>


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.  

Hope your issue has been solved :-)  

QUERIES in Oracle, Feel free to Join:  

http://groups.yahoo.com/group/oracle_expert/  

Regards,

Sunil Bhola

Oracle_Expert, Moderator

Connor McDonald <mcdonald.connor_at_gmail.com> wrote: Oracle database IO on windows is automatically direct IO akaik...

hth
connor

On 6/23/05, Amihay Gonen wrote:
>
> Hi ,
> Can I use directIO (disable file cache) on windows platform ?
>
> I've tried to search but I haven't find answer.
>
>
> Amihay Gonen
> DBA,
> 972-3-9268280
>
> Be there ... -> http://golan/Forum%20DBA/default.aspx
>

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l


QUERIES in Oracle, Feel free to Join:
 
http://groups.yahoo.com/group/oracle_expert/ 

 
Regards,
Sunil Bhola
Oracle_Expert, Moderator











		
---------------------------------
Do you Yahoo!?
 Make Yahoo! your home page   
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 23 2005 - 09:54:44 CDT

Original text of this message

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