Oracle 锁表

• 查询Oracle锁表

select sess.sid,sess.serial#, lo.oracle_username,lo.os_user_name, ao.object_name,lo.locked_mode  from v$locked_object lo,dba_objects ao,v$session sess where ao.object_id=lo.object_id and lo.session_id=sess.sid;

• 杀掉锁表进程

alter system kill session '68,51';--分别为SID和SERIAL#号