enq: TM - contention top wait event in awr
Hello,
I am working on oracle 11.1.0.7 on AIX.Some time back user has reported slowness in production database.
I have checked awr reports and find out that the top wait event 'enq: TM - contention' .
During this time db time is more then elapsed .
I found multiple insert statements from the module which was runing slow.
I checked that all insert statements are on some table. For further investigation i check all child tables of this table for foreign key and index on that.
All coulmns used in FK is indexd....and those tables also those are parent to this table.
Any idea what we need to check now ...for analysis of slowness.