RE: Asynchronous I/O on Solaris

Jared,
  I haven't seen any discussion of asynchronous I/O in Cockcroft's second book...

Jeff S

-----Original Message-----
From: Jared Still [mailto:jkstill_at_bcbso.com] Sent: Tuesday, November 14, 2000 8:11 AM To: Multiple recipients of list ORACLE-L Subject: RE: Asynchronous I/O on Solaris

On Mon, 13 Nov 2000, Steve Adams wrote:

> Hi All,
>
> It seems that the issue of asynchronous I/O on Solaris is still alive and
> kicking. Here is an attempt to pull the threads together.
>
> Oracle 7 had an 'async_write' parameter that used to default to TRUE. If
set to
> FALSE, Oracle would use the standard 'write()' system call to do
synchronous
> writes. So DBWR for example would have to wait for each physical I/O
operation
> to complete before it could do anything else. So if DBWR needed to write 1
block
> to each of 10 disks, all those write operations would be done in series.
The
> intent of the default use of asynchronous I/O was to allow multiple writes
to
> distinct disks to be performed in parallel by a single process.
>

...

Steve, thanks for this very clear and well thought out explanation.

It would take days to glean this information from Sun tech support, manuals, web searches, etc., and more time to create a concise explanation of it.

I still don't have the second edition of Cockroft's book; is any of this included in there?

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_bcbso.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).