oracle相关

杀掉接口服务器ORACLE进程
SELECT 'kill -9 ' || SPID || ';'
  FROM V$PROCESS p, V$SESSION s
  WHERE p.addr = s.PADDR
   and s.MACHINE in ('zjddinter1', 'zjddinter2')

查看综合调度系统所有服务器的连接数
select t.MACHINE,count(*) from v$session t
where t.MACHINE in ('zjddapp1','zjddapp2','zjddrep2','zjddtestweb','zjddinter1','zjddinter2')
group by t.MACHINE

杀掉应用服务器，接口服务器ORACLE进程
SELECT 'kill -9 ' || SPID || ';'
  FROM V$PROCESS p, V$SESSION s
 WHERE p.addr = s.PADDR and
       s.MACHINE in ('zjddapp1', 'zjddapp2', 'zjddrep2', 'zjddtestweb',
        'zjddinter1', 'zjddinter2')

重新调度JOB脚本(sys用户执行)

ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0，等待2－3分钟 ，
在执行 ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 10