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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
