Re: Index Maintenance Vs Insert Response Time
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Wed, 8 Feb 2012 10:07:12 +0100
Message-ID: <4F323B40.6070701_at_nordea.com>
W dniu 07.02.2012 16:23, Antony Raj pisze:
> Hi All,
>
> Our application have a staging table which has 3 indexes on it.There are two INSERTs running everyday by selecting different sets of data from other application tables.Both inserts were inserting
> ~ 45,000 rows everyday.The current row count of this table is 32 million(Not partitioned).
>
> Both INSERTs took ~ 1-2 minutes until the table's row count has reached 10 million and then the elapsed time has been increased to 6-7 minutes
> Since we insert the same amount of rows into this table,the expectation from the developers is that the inserts should run within 2 minutes all days.
> Any explanations?
>
> Thanks
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Date: Wed, 8 Feb 2012 10:07:12 +0100
Message-ID: <4F323B40.6070701_at_nordea.com>
W dniu 07.02.2012 16:23, Antony Raj pisze:
> Hi All,
>
> Our application have a staging table which has 3 indexes on it.There are two INSERTs running everyday by selecting different sets of data from other application tables.Both inserts were inserting
> ~ 45,000 rows everyday.The current row count of this table is 32 million(Not partitioned).
>
> Both INSERTs took ~ 1-2 minutes until the table's row count has reached 10 million and then the elapsed time has been increased to 6-7 minutes
> Since we insert the same amount of rows into this table,the expectation from the developers is that the inserts should run within 2 minutes all days.
> Any explanations?
>
> Thanks
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
this sounds very similar to what we experienced yesterday - You may take a look at "weird insert behaviour" thread and INSERT slow on ASSM [ID 1263496.1] as Greg indicated
-- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com> pos : DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, NIP: 586-000-78-20, REGON: 190024711-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 08 2012 - 03:07:12 CST