Home » SQL & PL/SQL » SQL & PL/SQL » Run procedures in parallel (without duplication)
Run procedures in parallel (without duplication) [message #199110] Fri, 20 October 2006 04:28 Go to next message
Messages: 20
Registered: October 2006
Location: Cape Town
Junior Member
I have a procedure that selects over 8 million records from one table into another. The select can be sorted by subscriber id which is the key on the source table.

This job runs way too long so I'm looking for a way to run the procedure in concurrent jobs.

I'm thinking of using the dbms_jobs package tot kick off maybe 5 - 10 jobs sumiltaniously, but I'm not sure how to handle the process so that it executes the subscriber id's in sequience without processing any of them twice.

Any help will be much appreciated !!

Re: Run procedures in parallel (without duplication) [message #199117 is a reply to message #199110] Fri, 20 October 2006 05:02 Go to previous message
Messages: 3186
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You might not even need to re-event the wheel, Oracle already has a built-in support for parallel execution of queries.

Example :

alter session enable parallel dml;
insert /*+ parallel (emp_big,4,1) */
  into emp_big select * from emp;
alter session disable parallel dml;

For more information have a look here :

Previous Topic: About Boolean Function
Next Topic: About Mutating(Trigger)
Goto Forum:

Current Time: Mon Oct 24 15:38:15 CDT 2016

Total time taken to generate the page: 0.06574 seconds