CJQ Process

[Chintz]

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

[davey23uk]

its the job queue processes, they are not vital to the database, only your job - what probs you havig?

[Chintz]

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

[slimdave]

Seems like the workaround condones it, so you'll be OK. I don't see what the problem would be.

[davey23uk]

et job_queue_processes to 0, then back to what it was before - that should 'recycle them'