1、执行下面SQL，先查看哪些表被锁住了:18:09:22SCOTT@wailon>selectb.owner荑樊综鲶,b.object_name,a.session_id,a.locked_modefrom v$locked_object a,dba_objects bwhere b.object_id = a.object_id;OWNER OBJECT_NAME SESSION_ID LOCKED_MODE------------------------------ -------------------- ---------- -----------SCOTT TAB_DL 144 3SCOTT TAB_DL 21 3
3、查看被阻塞的会话18:11:09SCOTT@wailon>select* from dba_waiters;WAITING_SESSION HOLDING_SESSION LOCK_TYPE MODE_HELD MODE_REQUESTED LOCK_ID1 LOCK_ID2--------------- --------------- -------------------------- ---------- --------------- ---------- ---------- 144 21 Transaction Exclusive Exclusive 655372 1186
5、最直接的方法就是：咨询专业技术人员来帮你操作完成
