Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

enq: WF - contention

736258Feb 17 2011 — edited Mar 20 2011

Hi,

I'm analyzing the AWR report and find the enq: WF - contention in the top 5 timed event.

enq: WF - contention 4,616 2,284 495 15.7 Other

From my research, it's basically the MMON processes is periodically flush ASH data into AWR tables. Oracle introduced the WF enqueue which is used to serialize the flushing of snapshot. But if this is the top event (30% of the database time), then it is a really issue. The ADDM report suggests to investigate the wait in service "SYS$BACKGORUND".

Is this has anything to do with the AWR settings?

Thank you in advance for any advice.

Sam

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2011

Added on Feb 17 2011

#general-database-discussions

6 comments

10,865 views