psaju
asked on
How can I execute stored procedures in parallel from a stored procedure?
I need to run in parellel multiple stored procedures with in a stored procedure to attain better performance. Can someone please provide sample code?
Use one of Oracle's prepackaged APIs, the DBMS_JOB package, to submit multiple jobs to a job queue and then run them in parallel.
This is an example code i found on the web for a procedure that is not done in parallel
declare
vStart number;
begin
vStart := dbms_utility.get_time;
Maintenance.RebuildIndex('ORDERS_PK', 'NOLOGGING PARALLEL');
Maintenance.RebuildIndex('SALES_PK', 'NOLOGGING PARALLEL');
Maintenance.RebuildIndex('ORDERS_AK1','NOLOGGING PARALLEL');
Maintenance.RebuildIndex('SALES_AK1', 'NOLOGGING PARALLEL');
dbms_output.put_line('Elapsed time: ' ||
round((dbms_utility.get_time - vStart)/100, 2) || ' hsecs' );
end;
/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.