Grid Control Performance: High 'Ul Contention' Seen for the Repository Database Sessions
(Doc ID 862527.1)
Last updated on MARCH 04, 2019
Applies to:Enterprise Manager Base Platform - Version 10.2.0.5 to 10.2.0.5 [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".
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 10.2.0.4 to 10.2.0.5.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document