-none- 2004-09-16 - By -not available-
"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
For technical support please email tech_support@(protected) or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____
This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@(protected)
--
http://www.freelists.org/webpage/oracle-l
|
|
