DBA场用SQL语句

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

-- 查看当前的等待事件
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;