SQLA:
select session.sid,session.serial#,lo.oracle_username,lo.os_user_name,ao_object_name,lo.locked_mode from v$locked_object lo,dba_objects ao, v$session where ao.object_id=lo.object_id and lo.session_id=session.sid;
SQLB:
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
杀掉进程:
alter system kill session 'SID,SERIAL#';