JOB_QUEUE_PROCESSES
535285Jul 17 2007 — edited Jul 17 2007I have set job_queue_processes =4 but i coundn't find any job processes getting created for the instance.
SQL> sho parameter job_queu
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 4
catccsrv01> ps -ef | grep ora_
oracle 754 1 0 Jan 16 ? 18:35 ora_pmon_GTDBLIVE
oracle 756 1 0 Jan 16 ? 5108:19 ora_dbw0_GTDBLIVE
oracle 758 1 0 Jan 16 ? 5103:58 ora_dbw1_GTDBLIVE
oracle 760 1 1 Jan 16 ? 17436:44 ora_lgwr_GTDBLIVE
oracle 762 1 0 Jan 16 ? 876:05 ora_ckpt_GTDBLIVE
oracle 764 1 0 Jan 16 ? 28:58 ora_smon_GTDBLIVE
oracle 766 1 0 Jan 16 ? 0:04 ora_reco_GTDBLIVE
oracle 768 1 0 Jan 16 ? 0:08 ora_cjq0_GTDBLIVE
oracle 770 1 0 Jan 16 ? 524:21 ora_arc0_GTDBLIVE
oracle 773 1 0 Jan 16 ? 522:54 ora_arc1_GTDBLIVE
oracle 21686 1 0 07:01:39 ? 5:36 ora_p003_GTDBLIVE
oracle 9993 1 0 May 28 ? 0:01 ora_cjq0_CONTACT
oracle 9989 1 0 May 28 ? 2:50 ora_smon_CONTACT
oracle 10442 10000 0 12:37:04 pts/2 0:00 grep ora_
oracle 21682 1 0 07:01:39 ? 1:27 ora_p001_GTDBLIVE
oracle 9983 1 0 May 28 ? 81:49 ora_ckpt_CONTACT
oracle 21680 1 0 07:01:39 ? 1:31 ora_p000_GTDBLIVE
oracle 9997 1 0 May 28 ? 11:14 ora_arc0_CONTACT
oracle 9974 1 0 May 28 ? 0:22 ora_pmon_CONTACT
oracle 21684 1 0 07:01:39 ? 6:44 ora_p002_GTDBLIVE
oracle 9991 1 0 May 28 ? 0:00 ora_reco_CONTACT
oracle 10001 1 0 May 28 ? 11:27 ora_arc1_CONTACT
oracle 9978 1 0 May 28 ? 231:18 ora_dbw1_CONTACT
oracle 9980 1 0 May 28 ? 356:06 ora_lgwr_CONTACT
oracle 21688 1 0 07:01:39 ? 2:01 ora_p004_GTDBLIVE
oracle 9976 1 0 May 28 ? 232:43 ora_dbw0_CONTACT
What could be the reason for this. The database name is GTDBLIVE.
IMP: DBMS JOBS was not created in the database GTDBLIVE. Will this have an impact in creating the job queue processes for the instance.
SQL> select count(*) from dba_jobs;
COUNT(*)
----------
0
cheers
kumareshan