FreeLists / oracle-l / RE: buffer busy waits

Yes, thank you KG, but I am wondering the same thing as Bambi.  Here are the 
top 3 functions output by the query you provided:

MODULE                         CALLS      WAITS CAUSED WAITS
------------------------- ---------- ---------- ------------
kdiwh09: kdiixs            191398675          0        95239
kdiwh22: kdifind            32024815          0       177736
kdswh05: kdsgrp           2.9645E+10          0      2515451

I searched Metalink and Google to no avail.

Thanks,
Brandon


-----Original Message-----
From: Bellows, Bambi [mailto:bbellows@xxxxxxx]
Sent: Monday, August 01, 2005 11:17 AM
To: john.kanagaraj@xxxxxxx; kaygopal@xxxxxxxxx; Allen, Brandon
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: buffer busy waits


Thanks for the nifty scripts!  You guys are really on top of your games
with the x$ calls.  But... Is there some kind of doc that tells you what
all the modules are?  Cuz some of this is pretty obvious, but then
there's the rest.

-----Original Message-----
On Behalf Of K Gopalakrishnan
Sent: Friday, July 29, 2005 3:57 PM
To: Brandon.Allen@xxxxxxxxxxx


Allen:

You can findout what are the _exact_ system calls causing the buffer
busy waits using the following SQL.  This will give a fair idea about
the operations causing the bbw and you can narrow down the cause/action
from the result.

SELECT WH.KCBWHDES "MODULE",SW.WHY0 "CALLS",SW.WHY2 "WAITS",
SW.OTHER_WAIT "CAUSED WAITS" 
FROM x$kcbwh WH, x$kcbsw SW
WHERE WH.indx = SW.indx
AND SW.OTHER_WAIT > 0
ORDER BY SW.OTHER_WAIT;

Basically by reducing the concurrency at block level, you can easily
combat the BBWs.


--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l