菜鸟认为:
既然没有提交,那他就被锁住了。16.怎么发现是谁锁住了你需要的一张表?Select object_id from v$locked_object;Select object_name, object_type from dba_objects where object_id=’’;
既然没有提交,那他就被锁住了。16.怎么发现是谁锁住了你需要的一张表?Select object_id from v$locked_object;Select object_name, object_type from dba_objects where object_id=’’;
Select SESSION_ID from v$locked_object;
select sid,program,terminal from v$session where taddr is not null;
http://expert.csdn.net/Expert/topic/2908/2908916.xml?temp=.5817682
2.可以使用dbms_alert包,具体我也没有用过,你看看相关文档吧。或者听听别人的意见
sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot"
from v$session_Wait
group by event order by 4