Re: buffer busy waits

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/
--
http://www.freelists.org/webpage/oracle-l

Other related posts: