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
2、查看引起死锁的会话18:09:24SCOTT@wailon>selectb.username,b.s足毂忍珩id,b.serial#,logon_time18:09:40 2 from v$locked_object a,v$session b18:09:40 3 where a.session_id = b.sid order by b.logon_time;USERNAME SID SERIAL# LOGON_TIME------------------------------ ---------- ---------- ------------SCOTT 21 53 27-SEP-13SCOTT 144 369 27-SEP-13
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
4、可以提交或回滚阻塞的话，释放锁或者杀掉ORACLE进程:ALTER SYSTEM KILL SESSION 'SID,SERIAL#'; --对应上例中的21,53
5、最直接的方法就是：咨询专业技术人员来帮你操作完成
