RE: buffer busy waits
- To: "Bellows, Bambi" <bbellows@xxxxxxx>, <john.kanagaraj@xxxxxxx>, <kaygopal@xxxxxxxxx>
- Date: Mon, 1 Aug 2005 12:08:35 -0700
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
