Re: slow insert performance

I ran statspack and the most wait is on: db file sequential read.
It is by far the biggest compared to the others.

I think the problem is because the db buffer cache is too tiny. It is only 120Mb now. Agree?

Daud

"DJ" <nospamplease_at_goaway.com> wrote in message news:<_RD9c.477$I8.211_at_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 Thu Apr 01 2004 - 02:35:50 CST