查询正在执行中的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#';