The views expressed on this blog are my own and not those of my employer or my clients. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine.
Maybe you don’t remember me. Im currently diagnosing a ASH report from a Oracle 11g RAC. I encountered a blocking sessions, with the wait event enq: WF – contention. Unfortunately the User name is not found. What can caused an “enq: WF – contention”? I only notice this because a used DBA_HIST_ACTIVE_SESS_HISTORY base on SID and INST_ID to generate a snap id. This might help my investigation.
Mico Lademora said
Hi Karl,
Maybe you don’t remember me. Im currently diagnosing a ASH report from a Oracle 11g RAC. I encountered a blocking sessions, with the wait event enq: WF – contention. Unfortunately the User name is not found. What can caused an “enq: WF – contention”? I only notice this because a used DBA_HIST_ACTIVE_SESS_HISTORY base on SID and INST_ID to generate a snap id. This might help my investigation.
Thanks