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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and Sun ufs

Re: Oracle and Sun ufs

From: Eberhard Niendorf <eberhard.niendorf_at_epost.de>
Date: Sat, 22 Jun 2002 05:14:26 +0200
Message-ID: <af0q6v$bi7$05$1@news.t-online.com>


Hi,

For Oracle 8.1.7

You should set:

        _filesystemio_options=setall
This enables both direct IO (mount option forcedirectio not neccessary) and async I/O.

In Solaris 8 Update 3 (Feb 2001) Concurrent Direct I/O is implemented. Performance close to raw devices should be possible (says SUN).

Regards,
Eberhard Niendorf

"Connor McDonald" <connor_mcdonald_at_yahoo.com> schrieb im Newsbeitrag news:3D1249D7.6A2A_at_yahoo.com...
> Gerold Krommer wrote:
> >
> > Hi,
> >
> > I'm planning to install Oracle 8.1.7 on Solaris 8. We only have ufs. I'm
> > thinking about raw devices versus file based Oracle, a topic beaten to
> > death in this newsgroup and I'm well aware of the pros and cons.
> >
> > I'm just trying to gather if there is any comment to using an ufs
filesystem
> > with the -logging option , disk_asynch_io set to TRUE, and
> > _filesystemio_options set to directIO.
> >
> > Thanks for any insight,
> >
> > /Gerold
> > g.krommer_at_nospam.fns.co.at
>
> simpler might just be to mount the file systems with the forcedirectio
> option
>
> But from a personal opinion - I love raw - it makes you deploy a far
> more disciplined system
>
> hth
> connor
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Fri Jun 21 2002 - 22:14:26 CDT

Original text of this message

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