Loading Tables in Parallel

[asth01]

Hi,

I have a requirement where I'll be extracting records from some 10 tables and load into another 10 tables.

I want this loading to happen in parallel.

I will write a PL/SQL procedure to accomplish it where I'll be passing table name and some search criteria. This will be inside a loop where records from source tables would be read and written to target table.

Can I write procedure in a way that will make loading of a table running in parallel with loading of another table?

Thanks in advance

 

[AOLEURO]

Hi

Why do you need to write a procedure? - is it because you are using FETCH (open cursor) instead of using DML (insert or merge with hints)?


Regards
Allan
Icq: 346225948

 

[asth01]

Yes. I have a dynamic cursor that reads and writes.

 

[AOLEURO]

Hi

The simples answer must bee to startup several sessions. Each session takes one table.

However the reason for your request for parallel – is properly because you got performance issues. You can never make good performance then using FETCH. You might have a chance if using bulk statements but properly not.


Regards
Allan
Icq: 346225948

 

[asth01]

How should I start several sessions?