How to measure slowdown caused by index updates
Hi,
A software uses a huge table HISTACTU (2,5 Gb and 18 881 529 rows).
7 indexes on that table have been created (8,5 Gb of data for all indexes).
Users experience slowdown on the software but hard to say when.
In statspack (I attached the report), I notice that :
db file sequential read is on the Top 5
sql ordered by elapsed time shows insert on the huge table is on the top
Does the update of the indexes occurs between each inserts ?
Is there a way to measure in statspack the slowdown caused by the indexes update ?
Rgds,
Frederic.