Yes it is. -----Original Message----- From: Roger Xu [mailto:roger_xu@xxxxxxxxxxx] Sent: Thu 9/16/2004 10:57 AM To: srospo@xxxxxxxxxxxxx Cc: Oracle-L@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@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.=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@xxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l