Oracle Database Discussions

Hi,

kkjcre1p: unable to spawn jobq slave process
Sat Apr 19 19:06:39 2008
Errors in file e:\admin\orcl\bdump\orcl_cjq0_1480.trc:


Sat Apr 19 19:06:40 2008
Process m001 died, see its trace file
Sat Apr 19 19:06:40 2008
ksvcreate: Process(m001) creation failed
Sat Apr 19 21:41:14 2008
Process J000 died, see its trace file
Sat Apr 19 21:41:14 2008
kkjcre1p: unable to spawn jobq slave process
Sat Apr 19 21:41:14 2008
Errors in file e:\admin\orcl\bdump\orcl_cjq0_1480.trc:


1 - This can be from the "processes" parameter being set too low. What is your current value? You have to bounce to change this parm.

2 - check your job_queue_processes parameter and make sure it not = 0

3 - Check your server stats, you may have run out of available server RAM resources

Can this processes be increased or are there any restrictions?

we have 200 users and so we set it up 2*200

Thanks,
Srikanth