Q
Problem solve Get help with specific problems with your technologies, process and projects.

New background process called "cjq"?

Is there a new background process called "cjq"? If yes, what is it? When I type "ps -ef |grep ora", I get a new background process called "ora_cjq0_TUN03". I get the usual lgwr, dbw0, ckpt, pmon, reco, but now I also get cjq0. Please explain. This is Oracle 9.2 and the sid is TUN03. It's a UNIX/AIX platform. Thanks.
Yes, this is a new background process for Oracle 9i. This process is the Coordinator Job Queue process. It handles automated jobs submitted with the DBMS_JOBS package. It will spawn Jnnn processes to actually run the submitted job. If you are not using DBMS_JOBS, then you can stop this process from starting by setting JOB_QUEUE_PROCESSES=0 in your initialization file or by the ALTER SYSTEM command.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close