Re: Oracle is painfully slow when doing massive INSERTs

You should probably look at the tables you are inserting into first:

Do they have alot of constraints? - you can disable them Are the INTIAL EXTENTS large enough to hold ALL of the data you are submitting? - you can increate the INITIAL size
Are you rollback segments large enough to hold all the data or are the extending themselves?

OR....

You might try exporting the data to a flat file and using SQL*Loader Direct Path load - this is very fast and does no error checking.

ALSO...
How much memory does you SGA have? If it is too small, your database buffers may be paging to disk...

Just some Ideas - I'll ask around

jgofpafb_at_aol.com (Oracle DBA) Received on Thu Mar 12 1998 - 00:00:00 CST