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.
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