Browse DevX
Sign up for e-mail newsletters from DevX


Run Oracle Stored Procedures in Parallel—Inside the Database

If you need a solution for running Oracle stored procedures in parallel, don't reinvent the wheel with solutions that run outside the database. Execute stored procedures in parallel inside the database using Oracle's native APIs and PL/SQL.




Building the Right Environment to Support AI, Machine Learning and Deep Learning

common misconception among Oracle developers is they can run stored procedures in parallel only from outside the database. For example, many use Java-based code that spawns multiple Java threads and runs each procedure on a separate thread (using the java.sql.CallableStatementobject), or UNIX shell scripts using cron to enable this function. But there's no need to reinvent the wheel this way—you can execute stored procedures in parallel inside an Oracle database using PL/SQL code. This 10-Minute Solution describes how, and it explains which types of tasks are suitable for this technique.

How do I run stored procedures in parallel from inside an Oracle database?

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.

Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date