snp background process is not running

[mallika]

I have the job_queue_processes=10 and job-queue_interval=60. i started my db. and if i do ps -ef |grep ora_sn it gives 0 reslut set.
let me know if i am hiting any oracle bug. My Oracle version is 8174.

[hrishy]

Hi

ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 2;

then do ps -ef|grep ora_snp


regards
Hrishy

[mallika]

even then not showing up.

[jovery]

Do your jobs execute?

I know the job queue process changed to cjq0 in 9i, I'm sure it was still snp in 8i but it might be worth checking to see if you have a cjq0 process. I don't have any 8174 instances here so I can't test it, but my 8170 instance still has snp processes.

Regards

[mallika]

Hi Jim:

It will get refreshed if i execute manually by
exec dbms_job.run(). it not through the snp process.

[jovery]

Are you getting any errors reported in your alert log or any trace files being generated which explains why the processes are either not starting or are being killed.

Regards

[mallika]

nothing there in alert log file. it says PL/SQL procedure succesfully completed.

[jovery]

Are the processes being registered in v$bgprocess

SELECT paddr, name, error
FROM v$bgprocess 
WHERE name like 'SNP%';

Regards

[mallika]

Hi Jim:
It gave the error 448 for the query u mentioned.

[jovery]

Very odd

When the instance starts it should record the SNP processes starting in the alert log and also any subsequent failure. Can you post the snippets of the alert log that shows these entries and are you sure no trace files are created?

Regards