Grid Control Performance: High 'Ul Contention' Seen for the Repository Database Sessions
Last updated on AUGUST 27, 2013
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.
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