Enq TM Contention vs Poor index performance
I have the following issue: I have a lot of Enq TM contention in my database. I then index the relevant tables/columns. This gets rid of the Enq TM issues, but performance is degraded even more due to the massive index reads. We have a good high performance disk system, so that's not the problem.
Has anyone had a similar issue? Aside from testing 101 different possibilities, does anyone have a recommendation on resolving this?
TIA,
Mike