Don,
The CJQ process (Coordinator Job Queue) is the process that spawns off
database jobs. Check the DBA_JOBS table for these, and DBA_JOBS_RUNNING
to see those that it thinks are active. Make sure these are set up
correctly and are not failing. You may find more information in the
database alert log or any logs that the database jobs may create.
HTH
John.
-----Original Message-----
From: Napasindayao Don (TEM)
[mailto:oracledba-ezmlmshield-x62018355.[Email address protected]
Sent: 08 January 2008 18:53
To: LazyDBA Discussion
Subject: DEFUNCT PROCESSES
Hey there LazyDBA Friends. Can anyone explain to me in detail what
DEFUNCT processes are and what causes them? We had to bounce the
database to elimate 10 defunct processes that were affecting the
application. Tried kill -9 for these processes, but to no avail.
Additional information: defunct processes have ora_cjq0_<SID_NAME> as
parent process.
Any feedback / info. is highly appreciated.
Best,
Don Napasindayao
Oracle Database Administrator
ABBOTT VASCULAR
26531 Ynez Road
Temecula, CA 92591, USA
Tel (951) 223-2780
don.[Email address protected]
www.abbottvascular.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.
Oracle LazyDBA home page