关于JOB_QUEUE_PROCESSES设置的问题
os:windows 2003
db:oracle10.2.0.1 rac
dd:2010-8-6
查看用户那边alert日志报错如下：
Fri Aug 06 11:22:21 2010
Process J000 died, see its trace file
Fri Aug 06 11:22:21 2010
kkjcre1p: unable to spawn jobq slave process
Fri Aug 06 11:22:21 2010
Errors in file
d:oracleproduct10.2.0adminorclbdumporcl1_cjq0_2864.trc:
错误分析：
该错误为JOB_QUEUE_PROCESSES参数值设置为10，由于设置过小，导致
oracle数据库无法创建新的JOB进程，建议增加该参数值大小。
SQL>alter system set JOB_QUEUE_PROCESSES=100 scope=both;
以下是网上搜到的错误分析：
Cause
JOB_QUEUE_PROCESSES parameter was set to 10 which is a small value.
JOB_QUEUE_PROCESSES specifies the maximum number of processes that can be created for the
execution of jobs. It specifies the number of job queue processes per instance (J000, ... J999).
That is why a lot of jobs died as in the alert log file when the parameter is set to such a small
value.
.
Solution
Make sure you are using SPFILE and then issue the following :
SQL>alter system set JOB_QUEUE_PROCESSES=500 scope=both;
Make sure that the value of the parameter has changed and then check if the error is still
generated in the alert log.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7417660/viewspace-1037748/ ，如需转载，请注明出处，否则将追究法律责任。
