foreign key constraint indexes

Performance issues due to enq: TM – contention

Dear Readers, Recently one of my clients facing weird issue, wherein some of application jobs were timing out. He raised a incident with us to check everything is fine from DB end. After checking active database sessions, I found some of update queries were having wait event “enq: TM – […]