有效關閉Oracle死鎖進程的具體步驟
查V$DB_OBJECT_CACHE視圖:
SELECT * FROM V$DB_OBJECT_CACHE WHERE OWNER=
查V$ACCESS視圖:
SELECT * FROM V$ACCESS WHERE OWNER=
查V$SESSION視圖:
SELECT SID
查V$PROCESS視圖:
SELECT SPID FROM V$PROCESS WHERE ADDR=
(
ALTER SYSTEM KILL SESSION
IXDBA
(
KILL
或者用ORAKILL(剛才查出的SID和SPID)
From:http://tw.wingwit.com/Article/program/Oracle/201311/19080.html