oracle中kill session的方法
在oracle中查找有多少表被锁住的方法:
select b.owner table_owner,b.object_name,c.username,c.sid,c.serial#
from v$locked_object a,dba_objects b,v$session c
where a.object_id=b.object_id and c.sid=a.session_id;
转载
2012-11-15 09:12:17 ·
661 阅读 ·
0 评论