-
CJQ Process
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'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|