SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

unix fork/wait? parallel process within a pl/sql procedure

vxwo0owxvApr 14 2011 — edited Apr 14 2011

Hi All

We like to record our process into a historical table.

And Let say base Table <a>, <b>, <c>, <d>

and

historical table <ha> <hb> <hc> <hd>

the report is a single process
but within which some of it is slow running and some of it is fast running

and we will have a RunId and a time_sk
a sequence and a number converted date format

e.g.
RunId = 1001
time_sk=20110414

so how can we achieve parallelism

in unix I can fork a process and wait for all the child process to finish
is there something like that in Oracle PL/SQL?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2011

Added on Apr 14 2011

3 comments

531 views