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

Home -> Community -> Mailing Lists -> Oracle-L -> Solaris 8 and asynch IO

Solaris 8 and asynch IO

From: <thump604_at_comcast.net>
Date: Fri, 19 Mar 2004 19:40:14 +0000
Message-Id: <031920041940.3229.56a5@comcast.net>


Happy Friday everyone!

I would like to hear from some others regarding their opinions and feedback in terms of asynch IO on Solaris when Veritas is not in the mix. OS Solaris 8
DB 8174

We know that if Quick IO or raw devices are not available that Solaris only simulates asynch IO with a failed kaio call and then the use of light weight threaded processes if disk_asycnh_io is set to true. If disk_asynch_io is set to false and dbwr_io_slaves are employed, then asycnh IO is simulated, but this time at the database level. My understanding is that IO slaves in terms of simulating asycnh IO can setrvice IO requests for most of the Oracle internal processes, where as OS pwrite/pread calls are more limited in what requests they can service.

With that, the question remains is there a hard answer or actual best practice in terms of disk_asycnch_io=false/true combined with db_writer_processes VS dwr_io_slaves?

I believe that the setting of false and 4 dbwr_io_slaves is optimal. I would like to hear what others think or have found on this matter.
--

- David / Thump
Life is what happens while waiting
or planning for the future.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Mar 19 2004 - 13:36:40 CST

Original text of this message

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