Oracle 表解锁

–查看数据库锁表的进程

select t2.username,       t2.sid,       t2.serial#,       t2.logon_time from v$locked_object t1,     v$session t2 where t1.session_id=t2.sid order by t2.logon_time;

–根据sid查询锁表的程序明细

select spid,        osuser,        s.program from v$session s,     v$process pwhere s.paddr=p.addr     and s.sid=51;

–kill语句

alter system kill session 'sid,serial#';