Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Async_io set up HP-UX for 10g Instances(these are apps instances)

Re: Async_io set up HP-UX for 10g Instances(these are apps instances)

From: Roby Sherman <rxsherm_at_interealm.com>
Date: Fri, 3 Aug 2007 11:52:56 -0600
Message-Id: <5D5B953B-1719-473F-98EB-346EB61505C6@interealm.com> 





>

> - disk_asynch_io is used to enable the oracle kernel to make use of  

> asynchronous io, IF the OS supports it.




And you really DO want to figure out if your OS supports it.  
Otherwise if you turn it on and its not supported, your database is  
essentially making two I/O calls for every one... One to aio_write  
(which fails) and then an immediate call to pwrite after. I can't  
tell you how many environments I come into where disk_asynch_io is  
set to true and it isn't supported.



--Roby

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


Received on Fri Aug 03 2007 - 12:52:56 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US