How To Analyze wait: ‘enq: HW – contention’

This wait can have an impact to production and deteriorate performance on a DB, so lets investigateā€¦ Lets see the output from a AWR report where this event is 23% of the total wait time: As per “Analyzing ‘enq: HW – contention’ Wait Event (Doc ID 740075.1)”, this can be generated by multiple sessions fighting... » read more