select * from v$locked_object;
select * from v$session a,v$locked_object b where a.sid = b.session_id;
alter system kill session ',';
2)kill掉这个死锁的进程:
alter system kill session ‘sid,serial#’; (其中sid=l.session_id)
select saddr,sid,serial#,paddr,username,status from v$session where username is not null;
(status 为要删除用户的session状态,如果还为inactive,说明没有被kill掉,如果状态为killed,说明已kill。)
select * from v$session a,v$locked_object b where a.sid = b.session_id;
alter system kill session ',';
2)kill掉这个死锁的进程:
alter system kill session ‘sid,serial#’; (其中sid=l.session_id)
select saddr,sid,serial#,paddr,username,status from v$session where username is not null;
(status 为要删除用户的session状态,如果还为inactive,说明没有被kill掉,如果状态为killed,说明已kill。)