RE: Please help me tune this "io done" wait event

Hans,

AFAIK, kproc is the slave process for AIO. How many do you see on your system? Maybe you have too many of them and are choking on CPU scheduling... Is your CPU stats Ok at this time? You need to have only as many AIO proces as there are *simultaneous* requests.... 300 maybe overkill.

Long time since I even touched AIX (4.2 last) so I may be way off-course here...
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

>-----Original Message-----
>From: Hans de Git [mailto:hansdegit_at_hotmail.com]
>Sent: Tuesday, October 07, 2003 8:44 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Please help me tune this "io done" wait event
>
>
>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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).