查看oracle数据库中表是否被锁
查出所有被锁住的表select b.owner TABLEOWNER,b.object_name TABLENAME,c.OSUSER LOCKBY,c.USERNAME LOGINID, c.sid SID, c.SERIAL# SERIAL from v$locked_object a,dba_objects b,v$session c where b.object_id = a.object_id AND a.SESSION_ID =c.sid;通过SID, SERIAL解锁alter sys
原创
2021-06-11 15:06:31 ·
1312 阅读 ·
2 评论