oracle

查询正在执行中的sql

SELECT sid, b.serial#, sql_text
FROM v$process a, v$session b, v$sqlarea c
WHERE a.addr = b.paddr
   AND b.sql_hash_value = c.hash_value;

查询锁的表

  select a.session_id, c.serial#, a.locked_mode, a.oracle_username, a.os_user_name, c.machine,
       c.terminal, b.object_name, c.logon_time
from   v$locked_object a, all_objects b, v$session c
where  a.object_id = b.object_id and a.session_id = c.sid
order  by c.sid, c.serial#; 

Kill 进程

  alter system kill session 'sid,serial#';