You can call procedures or packages in parallel. Oracle lets us maintain by using sys.dbms_parallel_execute package. At first glance, understanding the package is not that easy. But I prepared an example, and you can easily add or subtract procedures from my template code.
Let’s see my example. I created 5 independent procedures. Name of our procedures : proc_B, proc_A, proc_R, proc_T, proc_U
I created a package pck_execute_parallel and it has 2 procedures. The first one is prc_job_list and it stores list of procedures. The other one is prc_run_parallel and it maintains parallelism.
Continue reading