查询锁表进程及杀掉进程

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#';