Hi Siva Prakash

Thank you very much... Your update comes very close to my question.. Thanks once again...

and i need a clarification that if i use dbms_job, i need to wait till my first record to complete the job... then it will proceed for next record and so on... am i correct ?

In the unix environment, is there any way to do as below:
-assign 1st record to worker1,
-assign 2nd record to worker2,
-assign 3rd record to worker3,
-assign 4th record to worker4 and
restart the workers..
-assign 5th record to worker1,
-assign 6th record to worker2,
-assign 7th record to worker3,
-assign 8th record to worker4 and.. so on repeat till last record to complete...

if i do like wise, performance will be improved to 4 times...

thanks and regards


and second recordeed, multi-process/worker to process my job simultaneousely, i mean