DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: CJQ Process

  1. 01-25-2007, 03:46 PM #1
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217

    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
    Reply With Quote Reply With Quote
  2. 01-25-2007, 05:21 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    its the job queue processes, they are not vital to the database, only your job - what probs you havig?
    Reply With Quote Reply With Quote
  3. 01-25-2007, 05:41 PM #3
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217
    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
    Reply With Quote Reply With Quote
  4. 01-25-2007, 06:16 PM #4
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Seems like the workaround condones it, so you'll be OK. I don't see what the problem would be.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  5. 01-25-2007, 06:32 PM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    et job_queue_processes to 0, then back to what it was before - that should 'recycle them'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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