Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.glorb.com!news2.telebyte.nl!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed01.sul.t-online.de!newsmm00.sul.t-online.de!t-online.de!news.t-online.com!not-for-mail
From: Rick Denoire <100.17706@germanynet.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Direct IO In RH 3.0
Date: Wed, 03 Mar 2004 23:20:39 +0100
Organization: T-Online
Lines: 25
Message-ID: <93mc40h98dig1le5kje5vj8c3v0nl2u9or@4ax.com>
References: <403002A1.3010805@removethis.yahoo.com>
Reply-To: 100.17706@germanynet.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.t-online.com 1078352298 01 6457 D5QfG7Al3zwSSxRd 040303 22:18:18
X-Complaints-To: usenet-abuse@t-online.de
X-ID: E6a-prZJreiekeJiAf+t7Z7pR+WUpUQlwy2eyqwFlNmSv+zWPofzoB
X-Newsreader: Forte Agent 1.7/32.534
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256234

Stan <stan0074@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.

A hint from the world wide usenet:
machine:~# raw /dev/raw/raw0 /dev/blockdevice
SVRMGR> create tablespace "DATA" datafile '/dev/raw/raw0' size nK;
where n is the size of the raw device minus 1 database block.

Besides, you can use asynchronous I/O by setting parameters
async_io=true and filesystem_io=something (from my head). You will
have to relink Oracle though, it is easy. And it can be done in RH AS
2.1.

In short, I was hoping that RH 3.0 would support direct_io, 2.1 with
ext3 doesn't.

Bye
Rick Denoire