Oracle查詢鎖表信息并結(jié)束進(jìn)程

Oracle查詢鎖：

SELECT A.OWNER 方案名,
A.OBJECT_NAME 表名,
B.XIDUSN 回滾段號(hào),
B.XIDSLOT 槽號(hào),
B.XIDSQN 序列號(hào),
B.SESSION_ID 鎖表SESSION_ID,
B.Oracle_USERNAME 鎖表用戶名,
decode(D.type,'XR','NULL','RS','SS(Row-S)','CF','SS(Row-S)', 'TM', 'TABLE LOCK', 'PW', 'TABLE LOCK', 'TO', 'TABLE LOCK', 'TS', 'TABLE LOCK', 'RT', 'ROW LOCK', 'TX', 'ROW LOCK','MR','S(Share)',NULL) 鎖定方式,
-
 

C.MACHINE 用戶組,
C.TERMINAL 機(jī)器名,
B.OS_USER_NAME 系統(tǒng)用戶名,
B.PROCESS 系統(tǒng)進(jìn)程id,
DECODE(C.STATUS,'INACTIVE','不活動(dòng)','ACTIVE','活動(dòng)') 活動(dòng)情況 ,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM 連接方式,
C.LOGON_TIME
FROM ALL_OBJECTS A,
V$LOCKED_OBJECT B,
SYS.GV_$SESSION C,
v$lock d
WHERE ( A.OBJECT_ID = B.OBJECT_ID )
AND (B.PROCESS = C.PROCESS )
and C.sid = d.sid
and B.LOCKED_MODE = D.LMODE
ORDER BY 1,2;

Oracle殺進(jìn)程：
alter system kill session '139, 182'
139 : sid
182 : sertal#

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]