Home » SQL & PL/SQL » SQL & PL/SQL » Maximum jobs that can be submitted (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
Maximum jobs that can be submitted [message #385959] Thu, 12 February 2009 00:53 Go to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
Hi,

I have the following scenario:

There are approximately .5 million jobs submitted to oracle using dbms_job.submit without any interval, ex below:

Begin Dbms_job.submit(jobno, what); commit; end;


There are as i said .5 million jobs that are submitted, but when i go ahead and query user_jobs, I get only around 34000 entries which decrease gradually indicating that the jobs are executing,

1. What happened to the other jobs ?

2. I know that the job_queue_processes value gives the maximum number of jobs that can be executed concurrently, but where are the other jobs that are not visible in user_jobs stored ?

3. Is there a limit to the number of jobs that we can submit
using dbms_job.submit ?


Re: Maximum jobs that can be submitted [message #385969 is a reply to message #385959] Thu, 12 February 2009 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe they are already executed.
Theorically there is no limit but...
I think 500,000 jobs is quite silly and I don't see any business reason to do this.

Regards
Michel
Re: Maximum jobs that can be submitted [message #385986 is a reply to message #385969] Thu, 12 February 2009 02:46 Go to previous message
NewLife
Messages: 170
Registered: April 2008
Senior Member
Well, 1st of all my apologies for the late reply, was out for lunch.

I too feel it's too silly have so many jobs but i need to talk to my counter-part who has written the code.

Thanks a lot for the info Michel Smile

Previous Topic: ORA-12052 fast refresh materialized view, complete works
Next Topic: Oracle SQL questions
Goto Forum:
  


Current Time: Sun Dec 04 12:52:42 CST 2016

Total time taken to generate the page: 0.08459 seconds