Oracle 表解锁

来源:互联网 发布:淘宝店铺自动回复语 编辑:程序博客网 时间:2024/06/16 06:54

–查看数据库锁表的进程

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#';
0 0
原创粉丝点击