how do i disable async io in 11iv3 (273 Views)
Reply
Regular Advisor
wvsa
Posts: 185
Registered: ‎02-20-1997
Message 1 of 4 (273 Views)
Accepted Solution

how do i disable async io in 11iv3

Greetings all;

Installing 10gr2 on a 11iv3 rx6600 box. Oracle does not like async io enabled. How can I disable async io on the server. Did change /dev/async perms to 660. Is there something else I should do?

Thank you in advance for your responses.

Please use plain text.
Valued Contributor
sen_ux
Posts: 166
Registered: ‎10-01-2008
Message 2 of 4 (273 Views)

Re: how do i disable async io in 11iv3

Hi,
You may need to set "fs_async" to 0.

sen

Please use plain text.
Respected Contributor
Frank de Vries
Posts: 733
Registered: ‎11-13-1996
Message 3 of 4 (273 Views)

Re: how do i disable async io in 11iv3

Hi

This is a bug in Oracle bug ref 5359528

I don't know is you had to change the perms though.

I had this prob also but on an Itanium box of HPux and I found a note on metalink Oracle bug ref 5359528:

sql> alter system set disk_asynch_io=false scope=spfile;
Look before you leap
Please use plain text.
Visitor
CurtisPatterson
Posts: 1
Registered: ‎04-28-2010
Message 4 of 4 (190 Views)

Re: how do i disable async io in 11iv3

The bug does not appear to have been fixed on Oracle 11.2.0.1.0.  I've been diagnosing random application disconnects to the DB and found an Oracle alert log refering to trace files that had thousands of entries stating "Ioctl ASYNC_CONFIG error, errno = 1".

 

Below is the SQL I used to see that the Oracle setting was wrong, and also the SQL I used to change it to FALSE (as stated in the original post).  Note that you must bounce the database after making the change.

 

 

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL> show parameter disk_asynch_io;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
disk_asynch_io                       boolean     TRUE

 

SQL> alter system set disk_asynch_io = false scope=spfile;

 

system altered

 

SQL> shutdown immediate;

...

SQL> startup;

...

... from the trailer park of the Milky Way.
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation