Parallel Processing from multiple clients

[Rama Krishna G]

Hi,

I have a procedure which will read the data from a dummy table and write it in to a other table. Dummy table contains more than 1 million records.

Here my actual requirement:

Is there any way to run the procedure in parallel from different clients with every 10k records, So cai I achieve this thru partitioning or any others.

Note : Table is locking while working with multiple clients and those are working slow.

Thanks in Advance