Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and Sun ufs
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