RE: Linux RAC and asynch io - OCFS & "filesystemio_options" parameter?

For the record (if anyone still interested in this thread) I found out recently;

• Oracle 9i supports ASYNC IO on Linux.
• Oracle OCFS supports ASYNC IO on Linux.

*HOWEVER* Oracle 9i RAC + OCFS + using ASYNC IO is NOT supported. ...but I am currently running it and I immediately notice that "shutdown immediate" hangs / terminates.

Have to "Ctrl+c" in my SQL> term and issue "shutdown immediate" again to stop the database!

Saw a simple bug logged on Metalink for HP and RAC for the same issue...no good info though.

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris Sent: Friday, January 14, 2005 3:06 PM
To: oracle-l_at_freelists.org
Subject: RE: Linux RAC and asynch io - OCFS & "filesystemio_options" parameter?

My config;
9205
ocfs 1.0.13-1

Anyone want to take a guess as to what "filesystemio_options" should be set to?

Could find a direct answer on Metalink...I would guess
"filesystemio_options=3D3Dasynch", because my (Cluster) filesystem
supports async IO?

PS I found no posted issues regarding database crashes, Linux & async I/O!?

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris Sent: Friday, January 14, 2005 1:50 PM
To: thump_at_cosmiccooler.org
Cc: oracle-l_at_freelists.org
Subject: RE: Linux RAC and asynch io/IO slaves

David,

Thanks for the info...I going to check metalink too, but go relink sometime today and run some laod tests.

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"

-----Original Message-----
From: delysid_at_amber.monochrome.net [mailto:delysid_at_amber.monochrome.net] On Behalf Of David
Sent: Friday, January 14, 2005 1:05 PM
To: thump_at_cosmiccooler.org
Cc: Marquez, Chris; matthewp_at_amazon.com; oracle-l_at_freelists.org Subject: RE: Linux RAC and asynch io/IO slaves

Everything I have read advocates aio on RHAS 3.0.

I have heard also it can cause crashes and corruption, but found no meat to that statement no open bugs for 9205/9206 on rhas 3.0 Anyone with any hard facts as to real issues or successes? Anyone done an IO slave implementation in Linux/RAC? IO slaves in many ways are more robust and multi purpose than asych IO functionality...but I'm wondering how that performs with RAC.

Yes, I would and will test either or both before consideration with prod, but looking for others insights if they have been down the road.

--
..
David

>>
>> Matthew,
>>
>>>>bugs related to 9i RAC on Linux and asynch io
>>
>> Can you point to any (bugs) specifically or should I just =
search=3D3D20

>> =3D

>> Metalink?
>>
>> I was considering  enabling this for my=20
>> 9iRAC/RHEL3ES...Oracle=3D3D20=3D20 (marketing, presentations) imply =
that=20
>> I should be doing this. Frankly

>> Oracle Corp. takes much credit for helping RH/Linux get to async-IO?
>>
>> Thanks,
>>
>> Chris Marquez
>> Oracle DBA
>> HEYMONitor(tm) - heymonitor.com
>> "Oracle Monitoring & Alerting Solution"

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