oracle数据库查看和解除死锁

查看死锁：

select sess.sid,     sess.serial#,    lo.oracle_username,     lo.os_user_name,     ao.object_name,     lo.locked_mode,SESS.machine    from v$locked_object lo,     dba_objects ao,     v$session sess where ao.object_id = lo.object_id and lo.session_id = sess.sid; 

杀死对应的进程：

alter system kill session '738,1429';