Re: slow insert performance

From: DJ <nospamplease_at_goaway.com>
Date: Sun, 28 Mar 2004 18:24:48 +0100
Message-ID: <_RD9c.477$I8.211@newsfe1-gui.server.ntli.net>

"Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0403280905.6b6af04d_at_posting.google.com...
> I have a big table (over 50 million rows). Insert into the table is
> very slow. Doing
> insert into xxx
> select * from xxx2
> takes over 1 hour when xxx2 has around 200K records. I guess the
> problem is with the index maintenance which the table has 5. Will
> partitioning help improve the insert performance? Anyway, we only need
> to keep 6 months data and partitioning seems to be the way to go.
> Please advise.
>
> Oracle 8.1.7.4 on HP-UX 11.0
>
> Daud

have you run statspack? do yoo have an IO problem? what is is the insert waiting on?

We have a table with up to a billiob rows in it, inserting 2 million more records with 11 indexes to maintain takes around 4 minutes Received on Sun Mar 28 2004 - 11:24:48 CST