Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to measure the time spent for updating the indexes during a DML operation

user5737343Jan 5 2017 — edited Jan 8 2017

Hello

I would like to be able to distinguish the time spent for inserting into an indexed table, and the time spent for updating the associated indexes.

Can anybody suggest a way to get this information ?

(Trying with and without indexes is not an acceptable solution.)

Thanks in advance for any suggestion !

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2017
Added on Jan 5 2017
13 comments
5,637 views