Skip to Content
author's profile photo Former Member
Former Member

Problem with Oracle Processes - ora_cjq0_<SID> and ora_qmnc_<SID>

Hello,

We are having problem with few Oracle Processes which are failing by themselves and also cosuming high CPU load. Few of the Processes are :

ora_cjq0_<SID>

ora_qmnc_<SID>

I did not find any relevant SAP Note about the above two Processes.

Could you please throw some light on the above two processes? Will they stop being acitve once their work is done?

Thanks,

Subbu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2011 at 10:08 AM

    Hi Subbu,

    ora_cjq0_<SID>: It means "Job Queue Process". This process is used for job scheduler

    ora_qmnc_<SID>: It means "Queue Monitor Process". This process is used for Oracle Streams Advanced Queuing.

    Check the database jobs on the database by executing the statement, below;

    select * from dba_jobs;

    And check currently running jobs;

    SELECT * FROM user_jobs_running;

    Best regards,

    Orkun Gedik

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      >> Session Type UserName ProcessName Sessions Busy WaitTime(ms) Total WaitTime(ms) Busy W%

      >> USER SAPSR3DB CJQ0 1 3.437 182.871 1,88

      >> The reason why i didnt find a log in /Oracle/<SID>/saptrace/background is the session type of process CJQ0 is USER type.

      >> But as you know, logs in UserTrace will not be differentiated by Process and its hard to find a trace for this process.

      Under the normal conditions, CJQ process should be a background session, but is a user session, in your case. With this parameter, I understand that is is forked by a client application. In order to find out root cause, I recommend you check remote connections to the database and user traces, as well. From this point on, it is really hard to guess what's running at the backstage, without connecting to your system.

      Best regards,

      Orkun Gedik

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2011 at 12:00 PM

    Hi,

    Could you please show us some error logs from trace files or alert.log?

    Also, would request you to check if the latest SBP has been implemented or not.

    And of course, the Oracle parameters as well.

    830576 Parameter recommendations for Oracle 10g

    Br,

    Venky.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.