| Maximum jobs that can be submitted [message #385959] |
Thu, 12 February 2009 00:53  |
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 #385986 is a reply to message #385969] |
Thu, 12 February 2009 02:46  |
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 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
