查看oracle是否锁表以及解决方法

(2)查看哪个表被锁

<span style="color: #0000ff">select</span> b.owner,b.<span style="color: #ff00ff">object_name</span>,a.session_id,a.locked_mode <span style="color: #0000ff">from</span> v$locked_object a,dba_objects b <span style="color: #0000ff">where</span> b.<span style="color: #ff00ff">object_id</span> <span style="color: #808080">=</span> a.<span style="color: #ff00ff">object_id</span>;

(3)查看是哪个session引起的

<span style="color: #0000ff">select</span> b.username,b.sid,b.serial#,logon_time <span style="color: #0000ff">from</span> v$locked_object a,v$session b <span style="color: #0000ff">where</span> a.session_id <span style="color: #808080">=</span> b.sid <span style="color: #0000ff">order</span> <span style="color: #0000ff">by</span> b.logon_time; 

(4)杀掉对应进程

执行命令：<span style="color: #0000ff">alter</span> system <span style="color: #0000ff">kill</span> session<span style="color: #ff0000">‘</span><span style="color: #ff0000">1025,41</span><span style="color: #ff0000">‘</span><span style="color: #000000">;
其中1025为sid,41为serial#.</span>

查看oracle是否锁表以及解决方法

标签：logo   color   执行命令   session   数据   oracle   img   sys   order