Re: filesystemio_options vs disk_asynch_io
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: stevenoyle1@xxxxxxxxx
- Date: Tue, 10 May 2005 22:20:57 +0800
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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Regards
Zhu Chao
www.cnoug.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
