某表死锁，请问在哪个数据字典中SELECT出来，并在远程SQLPLUS中如何KILL该session

[PEPSIFOREVER]

RT
谢谢

[yag96]

v$lock

[hammer_shi]

alter system kill session '7,5';//分别为v$session中对应的sid和serial#的值

[shahand]

v$locked_object

[shahand]

或者dba_dml_locks

[shahand]

弄错了dba_dml_locks，我的815是没有的


select s.sid,s.machine,o.object_name,l.oracle_username,l.locked_mode,
'ALTER SYSTEM KILL SESSION '''||s.sid||', '||s.serial#||''';' Command
from v$locked_object l,v$session s,all_objects o
where l.session_id=s.sid and l.object_id=o.object_id;


select /*+RULE*/s.machine, s.osuser "O/S-User", s.username "Ora-User", s.sid "Session-ID", s.serial# "Serial", s.process "Process-ID", s.status "Status",l.name "Obj Locked", l.mode_held "Lock Mode"
from v$session s,dba_dml_locks l,v$process p
where l.session_id = s.sid and p.addr = s.paddr
;

[yellowzhong]

问的好，答的也好

[pollipop]

那么麻烦干吗！在PLSQLDev.exe中选择tools－》session，选择锁表的那个进程，kill

[leecooper0918]

人家问的是查询哪个表导致死锁? 不是问怎么去杀掉进程.