Re: buffer busy wait for insert session

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Thu, 19 May 2005 20:29:40 +0100 (BST)
Message-ID: <20050519192940.8201.qmail@web30906.mail.mud.yahoo.com>

Zhu:

Is that table partitioned? I would go for HASH partitioning as you need to throw the incoming rows in to multiple blocks and this will reduce the contention for 'concurrnet write' BBW.

Can you run the following query and identify which functions cause the buffer busy waits?

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;

Have a nice day !!

---

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 Received on Thu May 19 2005 - 15:34:22 CDT