OEMM Database Maintenance Task Not Running or Running Very Slow
Last updated on MARCH 08, 2018
Applies to:Oracle Enterprise Metadata Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
The default installation of Oracle Enterprise Manager (OEMM) provides a maintenance script to maintain database indexes and statistics properly in the OEMM repository. This automated script sometimes may not trigger or it may run for long hours (more than 10 hours) on large OEMM repositories.
There are no errors associated with the issue, but, the failure of the script to start or the long running may affect the OEMM UI performance as the repository will not be optimized.
Below is a screenshot showing how the Database Maintenance script is defied on OEMM.
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