Re: Inserts are taking time !

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).