--查找某用户下的所有锁
select a.*,b.object_name
from v$locked_object a ,all_objects b ,v$session c
where a.OBJECT_ID=b.object_id
AND a.SESSION_ID=c.SID
and c.USERNAME='aaa'
select a.*,b.object_name
from v$locked_object a ,all_objects b ,v$session c
where a.OBJECT_ID=b.object_id
AND a.SESSION_ID=c.SID
and c.USERNAME='aaa'
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time
alter system kill session 'sid,serial#';
TOAD在哪里看呢?
在菜单栏 DBA -> KILL/TRACE SESSION 里的其中一个标签页上