"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?
