I've been to pushchitz site couple of times but somehow i missed this
link. Thanks for sharing it.
Anyways, i've been using aio with RH 30 for a while and no issues so
far. Now that i know ext3 doesn't support direct_io, i got to look into
other alternatives.
Rick Denoire wrote:
> Stan <stan0074_at_removethis.yahoo.com> wrote:
>
>
>>Environment : Oracle 9.2.0.4, RH 3.0 ES
>>
>>Does ext3 fs support direct io. I couldn't find anything that is
>>equivalent to forcedirectio as in solaris ufs. I have been using noatime
>>for a while otherwise there weren't much changes done to default ext3 fs
>>mount points. Any advice or caveats appreciated.
>
>
> See what I found:
> Tuning and Optimizing Red Hat Linux Advanced 2.1 Server for Oracle9i
> Database
> http://www.puschitz.com/TuningLinuxForOracle.shtml
>
> There you can read:
>
> ##########################
> The filesystemio_options init.ora parameter needs to be set to asynch:
>
> filesystemio_options=asynch
>
> This init.ora parameter is platform-specific. By default, this
> parameter is set to none for Linux and thus needs to be changed.
>
> SQL> select value, isdefault from v$parameter where name =
> 'filesystemio_options';
>
> VALUE ISDEFAULT
> ------------------------------ ---------
> none TRUE
>
> SQL>
>
> The filesystemio_options can have the following values with
> Oracle9iR2:
> asynch: This value enables asynchronous I/O on file system files.
> directio: This value enables direct I/O on file system files.
> setall: This value enables both asynchronous and direct I/O on file
> system files.
> none: This value disables both asynchronous and direct I/O on file
> system files.
> #############################
>
> Bye
> Rick Denoire
>
--
-Stan
To reply remove the obvious ones from my email address
Received on Fri Mar 05 2004 - 00:12:04 CST