Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Q: does DirectIO on windows is supported on file systems ?
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-lReceived on Thu Jun 23 2005 - 09:54:44 CDT
![]() |
![]() |