Hi all,
I have come across this problem. We are currently running Oracle 7.3.4.
I tried to start Job Queue Processes by restarting the database, I have checked that relevant parameters are set in init.ora file, such as
JOB_QUEUE_PROCESSES=6
JOB_QUEUE_INTERVAL=10
JOB_QUEUE_KEEP CONNECTIONS=TRUE
But, why I can't see ora_snp* processes when I issued 'ps -ef|grep snp' after DB is up:
So were these 6 processes started in this case? Is there any other way to check their existance.
We are using ERP (not Oracle though), if those 6 processes were not up, why some of the jobs I submitted from ERP application are having status as 'pending' or 'working'.
Please advise, thanks a lot.
