Within the Oracle 10g environment is the proces 'CJQ' a process that needs to be up in order for the database to be up? Can we bounce the CJQ process without bringing the database down?
Chintz
Printable View
Within the Oracle 10g environment is the proces 'CJQ' a process that needs to be up in order for the database to be up? Can we bounce the CJQ process without bringing the database down?
Chintz
its the job queue processes, they are not vital to the database, only your job - what probs you havig?
I am getting the following error in the database logs :
ORA-00604: error occurred at recursive SQL level 2
ORA-01003: no statement parsed
which then leads to a ORA-4031 error.
I found a doc that says that I might be hitting Bug 3289063
ORA-1003 every 5 seconds after CJQ hits ORA-4031
The workaround for that bug is to recycle the CJQ process.
Chintz
Seems like the workaround condones it, so you'll be OK. I don't see what the problem would be.
et job_queue_processes to 0, then back to what it was before - that should 'recycle them'