Grid Control Performance: High 'Ul Contention' Seen for the Repository Database Sessions

(Doc ID 862527.1)

Last updated on AUGUST 27, 2013

Applies to:

Enterprise Manager Base Platform - Version to [Release 10.2]
Information in this document applies to any platform.
Checked for relevance on 27-Aug-2013


Login to Grid Console and navigate to Targets -> Databases -> click on Repository Database -> Performance. The following are noticed:

-  From Performance "Top Activity" for the Repository, there is a significant amount of "Application Waits".

-  There are many (around 10) Active Sessions by OMS under the "Top Sessions".

-  The "Top SQL" is:

MGMT_JOB_ENGINE.process_wait_step(:2);END; EMDW_LOG.set_context; END;

The "SQL Details" for this SQL shows significant "enq:UL - contention".

The "Statistics" for this SQL shows the Module is
"OEM.CacheModeWaitPool" with "Application Waits" taking up approximately 95% of "Activity by Waits".

Note: enq:UL - contention "translates" to Application "PL/SQL User Lock"

The EMDiag (repvfy) report from the repository shows there are 1000+ jobs shown for the Jobs test
116. Stuck wait executions


OMS has recently been uprgaded from to


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms