1.查询死锁语句

select b.username,b.sid,b.serial#,logon_time, b.sid||','||b.serial#

from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time;

 

 

2.删除死锁语句

SQL> alter system kill session '845,61926';

SQL>

alter system kill session '845,61926'

ORA-00031: 标记要终止的会话

SQL> alter system kill session '845,61926' immediate;

System altered