Parallel PL execution

[jpavus]

My first time here and I just want to post a question. How can the parallel processing be done. e.g. 5 .pl executables and I want to run them at the same time and have a status of each and one of them whenever they finish. It will produce a file on each executables and then be rolled up in one. They will also access the oracle DB. OR Have one pl executable with parallel processing or ORAPERL cursors. It is possible to achieve a parallel queries in ORACLE but its to much hassle because of partitions and stuff than having a script that runs simultaneously. thanks

[Zaxo]

What you want is doable with fork or and wait. You will want to call wait in list context so you can examine exit status. POSIX.pm, from the standard perl distribution, is invaluable for fine-tuning the children's environment.

Super Search for fork and wait will land you plenty of advice to get you started.

After Compline,
Zaxo

[tilly]

You can find an old version that I wrote at Run commands in parallel.

These days it is probably easier just to go with Parallel::ForkManager.