Re: Oracle is painfully slow when doing massive INSERTs
Date: 1998/03/12
Message-ID: <6e82ob$9pm$1_at_elle.eunet.no>#1/1
[Quoted] Joel Garry wrote in message <6e78ev$sdj$1_at_pebble.ml.org>...
>Do you have indexes? Have you done this without them, rebuilding
afterwards?
[Quoted] [Quoted] 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?
[Quoted] 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?
[Quoted] [Quoted] We're using Oracle 7.3.3.0.0, with all the default settings (whatever that
is). And yes; all
[Quoted] our Oracle files reside on the same disk. I'll try checking the SGA...
Received on Thu Mar 12 1998 - 00:00:00 CET