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:[EMAIL PROTECTED]
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 IOWhat 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
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).