随笔- 2
文章- 0
评论- 0
03 2008 档案
Oracle中查找锁住的表并解锁
摘要: --查出所有被锁住的表selectb.ownerTABLEOWNER,b.object_nameTABLENAME,c.OSUSERLOCKBY,c.USERNAMELOGINID,c.sidSID,c.SERIAL#SERIALfromv$locked_objecta,dba_objectsb,v$sessioncwhereb.object_id=a.object_idANDa.SESSION_...阅读全文