 DBMS_JOB for parallel processing [message #186248] |
Mon, 07 August 2006 03:02 |
quest_nisha
Messages: 4
Registered: August 2006
Location: Bangalore
|
Junior Member |
|
|
HI,
I am trying to tune an application which is taking 8hr's. Can I use dbms_jobs to parallel process the application..
I am trying something like this, application has to process for 11 templates in parallel.. and finally insert the data calculated in a common table...
FOR record IN cursor LOOP
EXIT WHEN cursor%NOTFOUND; /* record contains 11 templates */
dbms_job.submit( job => vJob,
what => 'Procedure(--);',
next_date => SYSDATE );
commit;
END LOOP;
But the application doesnt run after using dbms_job..i.e no record are inserted in the final table.. the user_jobs tables shows that the jobs failed..
Is there anything I am missing here..????
What are the risks involved in using jobs???
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
