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_at_usg.com] Sent: Monday, August 01, 2005 11:17 AM
To: john.kanagaraj_at_hds.com; kaygopal_at_gmail.com; Allen, Brandon Cc: oracle-l_at_freelists.org
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_at_oneneck.com

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 Received on Mon Aug 01 2005 - 14:09:28 CDT