RE: UFS direct I/O ?

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Thu, 16 Sep 2004 11:08:14 -0400
Message-ID: <E1732F21A9B99440B2117A3BEC76B91D2FE730@ztangousexch.ad.ztango.com>

Yes it is.

-----Original Message-----

From:	Roger Xu [mailto:roger_xu_at_dp7uptx.com]
Sent:	Thu 9/16/2004 10:57 AM
To:	srospo_at_watchmark.com
Cc:	Oracle-L_at_Freelists. Org (E-mail)
Subject:	RE: UFS direct I/O ?

We do not define filesystemio_options in our init.ora file. But:
SQL> show parameter filesystemio
=20

NAME                                 TYPE        VALUE
------------------------------------ ----------- =
------------------------------
filesystemio_options                 string      asynche/PR2/920_64/dbs/

=20
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_at_watchmark.com] Sent: Wednesday, September 15, 2004 5:23 PM Cc: Oracle-L_at_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?

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

For technical support please email tech_support_at_dp7uptx.com 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.=20
____________________________________________________________________
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_at_dp7uptx.com.
--
http://www.freelists.org/webpage/oracle-l



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

Received on Thu Sep 16 2004 - 10:05:04 CDT