oracle 死锁 问题

 /*
 1. 检查死锁 的sql 语句 
 */
 select event,username,sid,serial#,status,last_call_et,sql_hash_value,prev_hash_value 
from v$session where    status='ACTIVE' and last_call_et>1 and username is not null;

 select *from v$sqltext where hash_value='sql_hash_value值 或者 prev_hash_value' order by piece;

 /*
 2.
 */
 SELECT s.sid, s.serial# FROM v$locked_object lo, dba_objects ao, v$session s WHERE ao.object_id = lo.object_id AND lo.session_id = s.sid;  
 --ALTER system KILL session '21,30367';
 ALTER system KILL session 'sid 值,serial# 值'; --清除 死锁