SELECT A.OWNER 方案名,
A.OBJECT_NAME 表名,
B.XIDUSN 回滚段号,
B.XIDSLOT 槽号,
B.XIDSQN 序列号,
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 机器名,
B.OS_USER_NAME 系统用户名,
B.PROCESS 系统进程id,
DECODE(C.STATUS,‘INACTIVE’,‘不活动’,‘ACTIVE’,‘活动’) 活动情况 ,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM 连接方式,
C.LOGON_TIME
FROM ALL_OBJECTS A,
VKaTeX parse error: Expected group after '_' at position 24: …BJECT 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
– and C.MACHINE =‘yuruli-PC’
ORDER BY 1,2;
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v
l
o
c
k
e
d
o
b
j
e
c
t
t
1
,
v
locked_object t1,v
lockedobjectt1,vsession t2
where t1.session_id=t2.sid order by t2.logon_time;
–查看锁
–alter system kill session ‘sid,serial#’;
–把锁给KILL掉
alter system kill session ‘146,21177’;