--查找SQL
select sql_id,sql_text from v$sql where sql_text like '%&1%';

-- 查看當(dāng)前的等待事件
select event,count(*) from v$session group by event order by count(*);

-- 拼接kill會話(rac)
select 'alter system kill session '''|| SID||',' || serial# ||''' immediate;' from gv$session where username='BAD_USER' and inst_id=1;