RE: UFS direct I/O ?
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: <srospo@xxxxxxxxxxxxx>
- Date: Thu, 16 Sep 2004 09:57:05 -0500
We do not define filesystemio_options in our init.ora file.
But:
SQL> show parameter filesystemio
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string asynche/PR2/920_64/dbs/
The value for $ORACLE_HOME is /oracle/PR2/920_64.
So it looks to me it replaced the first 6 characters in the path name to
init.ora file with "asynch". Is this the default value for filesystemio_options
?
-----Original Message-----
From: Steve Rospo [ mailto:srospo@xxxxxxxxxxxxx]
Sent: Wednesday, September 15, 2004 5:23 PM
Cc: Oracle-L@Freelists. Org (E-mail)
Subject: 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?
--
//www.freelists.org/webpage/oracle-l
For technical support please email tech_support@xxxxxxxxxxx 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@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
