It could be the JOB_QUEUE_PROCESSES is 2 in your database
(show parameter job in svrmgr to show the actual value)JOB_QUEUE_PROCESSESThe job queue (or SNP) background processes are started when the Oracle instance is started. There are as many SNP processes started as specified in the INIT.ORA parameter JOB_QUEUE_PROCESSES. The range of valid values is from 0 to 36, so there can be a maximum of 36 SNP processes per Oracle instance. Under most operating systems, the characters SNP will appear as part of the process name. For example, under UNIX, an Oracle instance called DEV with three job queue processes would show the following process names:ora_DEV_snp0
ora_DEV_snp1
ora_DEV_snp2One significant difference between the SNP background processes and other Oracle background processes is that killing an SNP process will not crash the instance. While you’re not likely to want to do this very often, this behavior is useful to know in case a job queue process “runs away” and consumes excessive resources. When an SNP process is killed or fails on its own, Oracle automatically starts a new one to replace it.
(show parameter job in svrmgr to show the actual value)JOB_QUEUE_PROCESSESThe job queue (or SNP) background processes are started when the Oracle instance is started. There are as many SNP processes started as specified in the INIT.ORA parameter JOB_QUEUE_PROCESSES. The range of valid values is from 0 to 36, so there can be a maximum of 36 SNP processes per Oracle instance. Under most operating systems, the characters SNP will appear as part of the process name. For example, under UNIX, an Oracle instance called DEV with three job queue processes would show the following process names:ora_DEV_snp0
ora_DEV_snp1
ora_DEV_snp2One significant difference between the SNP background processes and other Oracle background processes is that killing an SNP process will not crash the instance. While you’re not likely to want to do this very often, this behavior is useful to know in case a job queue process “runs away” and consumes excessive resources. When an SNP process is killed or fails on its own, Oracle automatically starts a new one to replace it.
解决方案 »
- ora-00907 缺少右括号
- 无法解释的删除触发器的一个奇怪现象
- 如何并发每次取前100条不同记录,高手请进
- oracle的to_number()有字母报错怎么解决?
- Oracle.DataAccess.Dll 2.0 的OracleCommand 执行后有没有返回影响的行数这一说?
- 提示非单组分组函数
- win7下 按照oracle 11g R2 安装过程中出现enterprice manager配置出错,安装完成后按照网上的方法自己手动配置,出现数据实例不可用
- 请教高手一个Group By的问题
- 高分 急求 Oracle监听失败问题
- 我被PRO*C弄得焦头烂额,马上给分
- 什么函数可以取得当前是一年中的第几周?
- 請各位高手展招!!!
这两个进程是什么名字?贴出来看看。