Oracle 查询被锁的表并解除锁定

查询：

SELECT s.sid,s.serial#,s.username,

decode(l.type,'TM','TABLE LOCK',

'TX','ROW LOCK',

NULL) LOCK_LEVEL,

o.owner,o.object_name,o.object_type,

s.SCHEMANAMe, s.terminal,s.machine,s.program,s.osuser,a.sql_text, a.action

FROM v$session s,v$lock l,dba_objects o,v$sqlarea a

WHERE l.sid = s.sid

and s.prev_sql_addr = a.address

AND l.id1 = o.object_id(+)

AND s.username is NOT Null;

解锁：alter system kill session 'sid,serial#';