oracle阻塞处理
--查看等待的sessionselect * from dba_waiters; --查看锁等待情况select distinct lk.SID,lk.ID1,lk.ID2,lk.LMODE,lk.REQUEST,lk.BLOCK,lk.TYPE,do.owner || '.' || do.object_namefrom v$lock lk,v$locked_object lo,dba_objects dowhere do.object_id = lo.OBJECT_IDand lo.SE.
转载
2021-09-08 11:41:40 ·
231 阅读 ·
0 评论