--锁表查询的代码有以下的形式:
select count(*) from v$locked_object;
select * from v$locked_object;
--查看是哪个session引起的
select b.username,b.sid,b.serial#,logon_time
from v$locked_object a,v$session b
where a.session_id = b.sid order by b.logon_time;
--查看锁表进程SQL语句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
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
--杀掉对应进程 (session 后的字符串为 SID,SERIAL#)
select count(*) from v$locked_object;
select * from v$locked_object;
--查看是哪个session引起的
select b.username,b.sid,b.serial#,logon_time
from v$locked_object a,v$session b
where a.session_id = b.sid order by b.logon_time;
--查看锁表进程SQL语句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;
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
--杀掉对应进程 (session 后的字符串为 SID,SERIAL#)
alter system kill session '611,12569';
一般 ,自己的session 锁了的进程,自己不可以杀掉 需要使用 新的session傻掉,否则会报 ORZ-00027:无法终止当前回话