1.查询锁表语句
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;
2.杀进程
alter system kill session 'sid值,serial#值';
3.查OS级别进程ID
select spid,oSUSEr,s.program from v$session s,v$process p where s.paddr=p.addr and s.sid='sid值';
4.root用户下
kill -9 spid值