Oracle执行update语句一直持续,无法成功
1. 查出哪些对象被锁:
select a.*,b.* from v$locked_object a,dba_objects b where b.object_id = a.object_id
2. 查出锁住对象的session ID 和serial#:
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_obj...
原创
2018-10-29 16:56:00 ·
3436 阅读 ·
0 评论