Re: Index Maintenance Vs Insert Response Time
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Feb 2012 10:07:12 +0100
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
> --
> //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@xxxxxxxxxx>
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
