如何查找oracle被锁住表的sid并kill
1、查询被锁(占用)的表的sidselect SESS.sid, SESS.SERIAL#, LO.ORACLE_USERNAME, LO.OS_USER_NAME,AO.OBJECT_NAME, LO.LOCKED_MODEfrom V$LOCKED_OBJECT LO, DBA_OBJECTs AO, V$SESSION SESSwhere AO.OBJECT_ID = LO....
原创
2019-07-29 17:49:22 ·
1873 阅读 ·
0 评论