DBMS_JOB problem

From: bhogak <bhogak_at_yahoo.com>
Date: Sat, 23 Jun 2001 18:45:10 -0500
Message-ID: <9h39kl$adt$1@bob.news.rcn.net>

Hi all,

We have around 22 stored procedures scheduled thru DBMS_JOB. At least, once every week, the jobs hang. If I query DBA_JOBS/DBS_JOBS_RUNNING views, I see 2-3 jobs running for more than 6-7 hours and the next_run_time column is not updated for all the other jobs. In such situations, we tried to remove all the jobs and resubmit them again. But it doesn't help. Once the DBA bounces the database, everything works fine.

We are using Oracle 8i (8.1.7) on Sun Solaris. The Job_Queue_Processes parameter in the init.ora is set to 4. (I think we have an Open TAR with Oracle on this and our DBA doesn't want to increase this parameter until Oracle asks him to do so).

All the stored procedures scheduled through DBA_JOBS have similar functionality. They periodically send a message thru DBMS_PIPE. So they do run pretty quickly when executed from SQL*Plus.

Any suggestions are appreciated.

Thanks.
bhogak. Received on Sat Jun 23 2001 - 18:45:10 CDT