Re: UFS direct I/O ?

>From Steve Adams:

http://www.ixora.com.au/notes/filesystemio_options.htm

"Similarly, the parameter may need to be set to either directIO or setall to avoid buffered I/O against file systems that support direct I/O but do not provide a direct I/O mount option."

Solaris does provide a direct I/O option so you don't need to touch filesystemio_options. In addition, "setall" enables async I/O which I don't think you can do against a UFS volume. (Or CAN you?)

S-

On Tue, 14 Sep 2004, Roger Xu wrote:

> Hi list,
>
> Anybody out there running Oracle 9.2.0.4.0, Solaris 9 64-bit on UFS
> mount oracle datafile filesystem with forcedirectio option and set
> the init.ora parameter filesystemio_options to setall?
> What kind of performance gain by doing this?

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