Oracle-L: Please help me tune this "io done" wait event

From: Hans de Git <hansdegit_at_hotmail.com>
Date: Tue, 07 Oct 2003 07:44:25 -0800
Message-ID: <F001.005D246E.20031007074425@fatcity.com>

Hi All,

We suffer buffer busy waits and io done waits during batch processing. The batch does direct-path inserts (via Sqlloader and insert-append) in a 16k blocksize database (JFS, AIX).

Async io servers = 300, maxreqs = 16384

What is the general approach to tune the "io done' wait event? The explanation in the Oracle manual is -of course- not clear to me:

"The session waits for an I/O to complete or it waits for a slave process to become available to submit the I/O request. This event occurs on platforms that do not support asynchronous I/O."

AIX does support async IO....What is the slave process? Which io has to complete? Which write has to complete?

Thanks.

Regards,
Hans de Git

Hotmail en Messenger on the move
http://www.msn.nl/communicatie/smsdiensten/hotmailsmsv2/

--

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

Author: Hans de Git
INET: hansdegit_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Tue Oct 07 2003 - 10:44:25 CDT