oracle生成批量杀掉active进程的sql
renjixinchina
2012-12-07 16:13:10
Linux操作系统
原创
select 'alter system kill session ' || '''' || a.SID || ',' || a.SERIAL# ||
''''||' ;'
from v$session a
where a.username = 'GF_HR_USER'
and a.STATUS = 'ACTIVE'
统计需要重建的索引
oracle 长sql监控