查詢DB執行中的物件:

SELECT * 

     FROM v$db_object_cache

WHERE locks > 0 AND pins > 0 AND type = 'PROCEDURE' --type = 查看哪種類型物件


查詢DB Session ID:

SELECT a.OBJECT, b.SID, b.SERIAL#

FROM SYS.V_$ACCESS a, SYS.V_$SESSION b

WHERE a.TYPE = 'PROCEDURE' AND a.SID = b.SID AND b.STATUS = 'ACTIVE'


刪除DB Session:

Session ID的組成為 SID + , + SERIAL#

Ex. SID = 157, SERIAL# = 59799 > Session ID = 157,59799

ALTER SYSTEM KILL SESSION '157,59799';


arrow
arrow
    全站熱搜

    Big Bear 發表在 痞客邦 留言(0) 人氣()