filesystemio_options vs disk_asynch_io

From: steve noyle <stevenoyle1_at_yahoo.com>
Date: Tue, 10 May 2005 06:34:37 -0700 (PDT)
Message-ID: <20050510133438.88102.qmail@web30505.mail.mud.yahoo.com>

I'm confused with the difference between setting

filesystemio_options=asynch and
disk_asynch_io=true

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

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=directIO. 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=directIO at the same time or is turning on forcedirectio at the mount point level sufficient to guarantee directio?

We are running 9.2.0.4 on Solaris 8.

thanks.

steve

---

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

Received on Tue May 10 2005 - 09:39:09 CDT