Oracle查看正在执行的SQL，当前被锁对象以及解锁对象

1、查看正在执行的SQL

SELECT b.sid,
       b.username,
       b.serial#,
       spid,
       paddr,
       sql_text,--正在执行的SQL,
       b.machine --计算机名
FROM v$process a, v$session b, v$sqlarea c
WHERE a.addr = b.paddr AND b.sql_hash_value = c.hash_value

2、查看oracle当前的被锁对象

SELECT l.session_id,
       s.serial#,
       l.locked_mode,
       l.oracle_username,
       l.os_user_name,
       s.machine,
       s.terminal,
       o.object_name,
       s.logon_time
FROM v$locked_object l, all_objects o, v$session s
WHERE l.object_id = o.object_id AND l.session_id = s.sid

3、解锁对象

alter system kill session 'session_id,s.serial#';