Re: Inserts are taking time !

No, just give it a little test.

Anjo.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 04, 2002 10:58 AM

> At 02:03 AM 9/4/2002, Anjo Kolk wrote:
> >Yep and you have given the answer yourself. It is the number of indexes.
I
> >think that if the number of records increase the number of levels
increase
> >and slowly but surely you need to update more and more blocks. I have
done
> >sone tests (an oher people I am sure) that show that there is an
expontial
> >increase in the amount of undo and redo generated for every index that
gets
> >added into the mix.
>
> I assume that you mean "exponential increase" metaphorically. I can't
> imagine that the amount of undo & redo would grow at anything greater than
> linearly.
>
>
>
> >You will probably see an increase in CPU time (assuming that you are the
only
> >process/session on the system).
> >
> >Anjo.
> >
> >
> >On Wednesday 04 September 2002 08:53, you wrote:
> > > Hi All,
> > >
> > > We have a table which can contain more than half a million records.
When we
> > > try to insert some 10k records in the empty table it get inserted in
10
> > > min. but as the size increases time taken to insert also increases.
After
> > > 350,000 records it takes around an hour to insert 10k records. There
are
> > > around 15 columns in it out of which 11 are indexed. There is one
> > > concatenated function-based index on two columns of Varchar type and
two
> > > separate index for the same two columns.
> > >
> > > I have checked the free space for the tablespaces to which the table
and
> > > indexes are attached to. They are in two separate tbs.
> > >
> > > Any clues why this is happenning.
> > >
> > >
> > > TIA
> > > Marul.
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Anjo Kolk
> > INET: anjo_at_oraperf.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> Justin Cave
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Justin Cave
> INET: jcave_at_cableone.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).