optimizing mass inserts and updates

From: Maija-Leena <kangasmaki_at_netti.fi>
Date: Thu, 04 Sep 2008 07:53:15 GMT
Message-ID: <LtMvk.44$4a1.16@read4.inet.fi>


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 ?


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

Original text of this message