Re: directio performance question

From: Max <trestusler_at_hotmail.com>
Date: 7 Jul 2003 06:12:07 -0700
Message-ID: <5a4548ca.0307070512.11f50e4e@posting.google.com>

a quick answer.
> >
> > Is there any performance benefit to having a plain ufs filesystem
> > mounted forcedirectio on solaris for oracle?
> >
> As you have already seen there isn't. Set disk_async_io to false and
> you should see a performance benefit.
>

Not to drag this on but searching metalink for solaris forcedirectio etc I see that Oracle and a lot of dba's recommend the forcedirectio option for plain UFS on solaris for performance...

I'll stop now and go back to sysadmining which I understand a little better than dbaing ...

Thanks.

> Sybrand Bakker
> Senior Oracle DBA
Received on Mon Jul 07 2003 - 08:12:07 CDT