Dear gurus

We have a pl/sql procedure, which is used to process for datapumping, it processes 20 records per min, ... we would like to improve the performance... we have tuned the code as much as possible to improve the performace with various aspects...

We have an idea, to post 4times same procedure with different arguments simultaneously, so it may improve performance 4 times (theoretically)...

Example:

Procedure1(ID1,Filename1) 20 rec processing the same time
Procedure1(ID2,Filename2) 20 rec processing
Procedure1(ID3,Filename3) 20 rec processing
Procedure1(ID4,Filename4) 20 rec processing

this is something like, the procedure has to be assigned in different worker / processor...

so, we need to have a controller script, which will control the operation of all those procedures, and once this process is completed for , it has to take next argument and processes..


Could someone throw some light on this...

regards

anandharaj