Re: Oracle is painfully slow when doing massive INSERTs

From: Morten Myrvold <someone_at_somwehere.no>
Date: 1998/03/12
Message-ID: <6e82ob$9pm$1@elle.eunet.no>#1/1

Joel Garry wrote in message <6e78ev$sdj$1_at_pebble.ml.org>...
>Do you have indexes? Have you done this without them, rebuilding
afterwards?
No, there are no indices (PKEYS exist, they're needed to verify that the data is valid)

>Have you pre-created from a compressed export and truncated the receiving
table?
Not sure I understood your question, but the destination database is created from the bottom up, starting with a CREATE TABLESPACE.

>Have you tried creating a dblink and inserting with a select statement?
>(Assuming you have software to do this).
We don't currently have the s/w to do this.

>Are you running in archivelog mode with too small
>logfiles (how often are the switches?)? How big is your SGA? Perhaps it
is
>too big causing swapping? Are all your Oracle files on one disk?
We're using Oracle 7.3.3.0.0, with all the default settings (whatever that is). And yes; all
our Oracle files reside on the same disk. I'll try checking the SGA... Received on Thu Mar 12 1998 - 00:00:00 CST