数据库（oracle）表解锁

来源：互联网发布：python 执行adb shell 编辑：程序博客网时间：2024/04/30 04:16

1.查询表锁

SELECT a.sid,a.serial#,a.username,a.program,b.os_user_name,c.object_name FROM v$session a,v$locked_object b,dba_objects c where b.session_id = a.sid and c.object_id = b.object_id order by a.logon_time;

2.解锁
alter system kill session'1025,41'; 其中1025为sid,41为serial#.

参考： 2014-12-19
select a.*, b.username,b.sid,b.serial#,c.object_name,logon_time from v$locked_object a,v$session b,dba_objects c where a.session_id = b.sid and c.object_id = a.object_id order by b.logon_time;
select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;
select b.username,b.sid,b.* from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time;
select a.*, b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b,dba_objects c where a.session_id = b.sid and c.object_id = a.object_id order by b.logon_time;
SELECT a.sid,a.serial#,a.username,a.program,b.os_user_name,c.object_name FROM v$session a,v$locked_object b,dba_objects c where b.session_id = a.sid and c.object_id = b.object_id order by a.logon_time;
select * from v$session;
select * from v$locked_object

alter system kill session'720,9997';

原文作者编辑地址：http://www.cnblogs.com/870386641drh/p/4241115.html

0 0