What is the “WF - Contention’’ Enqueue ? (Doc ID 358208.1)

In this Document
Goal
Solution

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.1.0.4 and later
Information in this document applies to any platform.

GOAL

You want to understand what the “WF - contention” enqueue is.

Oracle 10g Reference Enqueue Names Appendix does not list this.

SOLUTION

MMON (Manageability Monitor) is attempting the autoflush function which means that we are trying to flush the ASH (Active Session History) data into the AWR (Active Workload Repository) for the historical repository.

We take out the WF enqueue for doing this and hence in your wait sessions you may see WF enqueue contention.