oracle 表解锁

查询当前锁的表：

select
s.username,
decode(l.type,'tm','table lock','tx','row lock',null) lock_level,
o.owner,
o.object_name,
o.object_type,
s.sid,
s.serial#,
s.terminal,
s.machine,
s.program,
s.osuser
from v$session s,v$lock l,dba_objects o
where l.sid = s.sid
and l.id1 = o.object_id(+)
and s.username is not null;

解锁：alter system kill session '179,4276';
注意最后面的参数结构为：'sid,serial'
如果上面的方法不行，就只能杀操作进程了：查询session对应的进程SELECT sid, username, paddr, status FROM v$session WHERE username = 'JCUSER' and sid=上面查出来的sid;
SELECT ADDR,PID,SPID,USERNAME,SERIAL#,TERMINAL FROM v$process WHERE addr　= '上面的PADDR'; 
杀掉spid所标识的那个进程
　　
orakill sid spid