oracle 查看以及解锁语句

 --查询被锁语句
SELECT /*+ rule */ s.username

,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK',NULL) LOCK_LEVEL

,o.owner

,o.object_name

,o.object_type,
s.sid

,s.serial#

,s.terminal

,s.machine

,s.program

,s.osuser
FROM v$session s     ,    v$lock l    ,   dba_objects o
WHERE l.sid = s.sid
AND l.id1 = o.object_id(+)
AND s.username is NOT Null

--解锁语句

 alter system kill session 'sid,serial#';

例如：alter system kill session '50,492';