SQL Performance (MOSC)

MOSC Banner

How to measure slowdown caused by index updates

edited Nov 8, 2016 4:01AM in SQL Performance (MOSC) 6 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center