DBA場用SQL語句
--查找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;

浙公網(wǎng)安備 33010602011771號