日期:2014-05-17 浏览次数:21040 次
一个update为什么会卡住呢 卡了半小时了
SELECT (select username FROM v$session WHERE sid=a.sid) blocker, a.sid, 'is blocking', (select username FROM v$session WHERE sid=b.sid) blockee, b.sid FROM v$lock a, v$lock b WHERE a.block = 1 AND b.request > 0 AND a.id1 = b.id1