how to update hundreds of big tables

I have to update a big number of Oracle tables efficiently. The names of tables and columns to be updated are obtained from a cursor and are based on column data type and schema names. Dynamic SQL is used to create the update statements. 10% of tables are bigger than the biggest rollback segment in the database. My question is: what is the most efficient method to perform this job? Should I use a cursor loop and sequentially update column after column commiting after every N rows? Or maybe create many processes (or threads) using Pro*C and submit these jobs concurrently (how many processes/threads)? Please, provide examples if possible.

Thank you!
Slavisa Brkic

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Dec 26 1998 - 17:22:26 CST