Programmatic parallelization

Hello all

I have some tasks (timeconsuming, some of them) that I need to speed up. Part of the tasks can run in parallel, but my problem is orchestration (that is, subtask 7 can proceed only when parallel subtasks 2-6 have all ended). Its easy to send subtasks 2-6 of using dbms_scheduler, but hen I lose control of when they terminate). Another option I have explored is to create a Java controller (residing in the database) that spawns a thread for subtask 2-6 and waits for the last one to complete. This works (the threading), but when each thread is assigned the