遭遇的情况:
解决办法:
一:找到锁住的罪魁祸首
select b.owner,b.object_name,l.session_id,l.locked_mode from v$locked_object l, dba_objects b where b.object_id=l.object_idselect b.o
遭遇的情况:
解决办法:
一:找到锁住的罪魁祸首
select b.owner,b.object_name,l.session_id,l.locked_mode from v$locked_object l, dba_objects b where b.object_id=l.object_idselect b.o