Re: filesystemio_options vs disk_asynch_io

From: zhu chao <zhuchao_at_gmail.com>
Date: Tue, 10 May 2005 22:20:57 +0800
Message-ID: <962cf44b050510072071128a72@mail.gmail.com>

Either is enough for enable directio.
For the difference between filesystemio_options=3Dasynch and disk_asynch_io=3Dtrue, the first one only applies to datafiles on filesystem, while the second apply to all datafile write. If the second is set to false oracle always disable asynch write.

On 5/10/05, steve noyle <stevenoyle1_at_yahoo.com> wrote:
> I'm confused with the difference between setting

>=20

> filesystemio_options=3Dasynch and
> disk_asynch_io=3Dtrue

>=20

> Which of the above two parameters determine if asyncio
> is turned on?

>=20

> The other confusion I have is we already have
> forcedirectio turned on at the mount point level for
> all oracle data files. The parameter,
> filesystemio_options was introduced in 9i and now
> according to the documentation we can turn on direct
> IO by setting filesystemio_options=3DdirectIO.
> So, now to use Direct IO for all Oracle data files, do
> we have to turn on directio at the mount point level
> and set filesystemio_options=3DdirectIO at the same time
> or is turning on forcedirectio at the mount point
> level sufficient to guarantee directio?

>=20

> We are running 9.2.0.4 on Solaris 8.

>=20

> thanks.

>=20

> steve

>=20
>=20


> __________________________________________________

> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Regards
Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 10 2005 - 10:25:27 CDT