Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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