Debugging a buffer busy waits
Date: Sat, 28 Mar 2009 18:30:33 +0100
Last day I've encountered a problem with a procedure waiting due to a buffer busy waits. In v$session_wait I've found FILE# and BLOCK#. Looking in DBA_SEGMENTS I've discovered incriminated blocks is belonging to a table called 'DUMMYTBL'.
Ok, now I can discover which other SIDs are using this table?
P3 code is 130 meaning no suitable images are found of this block. Deadlock are not signalled in alert.log.
Ste Received on Sat Mar 28 2009 - 12:30:33 CDT