optimizing mass inserts and updates

Hi,

I'm converting data from Oracle7 to Oracle10 and the tables and the data change a lot. The main conversion is done by insert-select (dynamic plsql) from imported old tables and that works fine and pretty fast even for big tables (more than 1 million rows), but extra upates that are often needed are a little bit slow. So I'm wondering how to speed them up. I'm going to cache my sequences and I create temporary indexes and also cache some small tables. Archiving and flashback are of course off. Is there a way to avoid using undo tablespace ? I don't need to rollback, if something goes wrong, I have to start over. I have one huge table where I insert rows for certain changes, so that table grows fast and is _really_ big.

Any tips ?

Regards,

Maija-Leena Received on Thu Sep 04 2008 - 02:53:15 CDT