SQL & PL/SQL

Hi All, I need your help on this...

There are two tables STANDARD and NEW, I also have a procedure which merges NEW table into STANDARD based on match and merge conditions .
Because these two tables are tooooooooo huge, its taking a very long time in weeks . It is anyway expected to take such a long time and is not a problem,
but sometimes it is getting into some database locking issues, to avoid these kind of issues and also...
I cannot wait for the updated data for so many weeks of time, atleast I would like to see or commit whatever is updated based on some specific intervals.

I would like to know how to enhance a merge statement so as to invoke a commit statement for every N number of records updated ... ???
OR
How to implement a CURSOR loop with a index variable and MERGE statement inside,
so that I can check the index variable in every iteration and invoke a commit statement for every N number of records modified ,
Please let me know whether it works or not and how to implement in case it works..

I would really appreicate your help on this....

Thanks.

Edited by: user8837073 on Oct 21, 2011 6:28 AM

Edited by: user8837073 on Oct 21, 2011 6:28 AM