SQL & PL/SQL

Hi Guys,

I have the following scenario and I would like to achieve parallel processing to increase data refresh performance:

Stored Procedure "SP1" - Refreshes Table A
Stored Procedure "SP2" - Refreshes Table B
Stored Procedure "SP3" - Refreshes Table C

I would like to be able to refresh table A, table B and table C in parallel, could someone help me identify ways in this could be achieved if something like this is possible?

I am using collections in stored procedures SP1, SP2 and SP3 to speed up table refresh time, although would like to know of a way to parallel update tables.

I have briefly heard of dbms_pipe package, would that be useful in this scenario?

Thanks,
Rohan