Re: Direct IO In RH 3.0

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Wed, 03 Mar 2004 23:52:29 +0100
Message-ID: <25oc40lhffccgu1i1kibh6jv39cqq7fagr@4ax.com>

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 Received on Wed Mar 03 2004 - 16:52:29 CST