select object_name,
machine,
s.sid,
s.serial# from v$locked_object ll,
dba_objects o,
v$session s where ll.object_id = o.object_id and ll.session_id = s.sid;
alter system kill session ‘141,8931‘;
原文：http://www.cnblogs.com/MZXS/p/5726658.html