Oracle查看表是否被锁及解锁

-- 查看锁表情况

SELECT

sn.username,

M . SID,
sn.SERIAL#,
M . TYPE,
DECODE (M .lmode,0,'None',1,'Null',2,'Row Share',3,'Row Excl.',4,'Share',5,'S/Row Excl.',6,'Exclusive',lmode,LTRIM (TO_CHAR(lmode, '990'))) lmode,
DECODE (M .request,0,'None',1,'Null',2,'Row Share',3,'Row Excl.',4,'Share',5,'S/Row Excl.',6,'Exclusive',request,LTRIM (TO_CHAR(M .request, '990'))) request,
M .id1,
M .id2
FROM
v$session sn,
v$lock M
WHERE(sn. SID = M . SID AND M .request != 0) 
OR (sn. SID = M . SID AND M .request = 0 AND lmode != 4 AND (id1, id2) IN (
SELECT s.id1, s.id2
FROM v$lock s
WHERE request != 0 AND s.id1 = M .id1 AND s.id2 = M .id2))

ORDER BY id1,id2,M .request;

-- 杀掉锁表进程来解锁

alter system kill session 'SID,SERIAL#';