--查询被锁语句
SELECT /*+ rule */ s.username
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.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
--解锁语句
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';