There are a few things you can try.
- If you can drop all indexes on the table, you should do so, then insert all of
the information into the table and then recreate the indexes again. This will
definitely speed up the insert because every insert, ORACLE has to resort the index
for each entry.
- From your explain plan numbers, it seems that your buffer cache miss ratio is
quite high, you can lower this cache miss ratio by increasing the initialization
parameter DB_BLOCK_BUFFERS.
I hope this helps.
Received on Wed Dec 16 1998 - 09:12:59 CST