My Oracle Support Banner

OEMM Database Maintenance Task Not Running or Running Very Slow (Doc ID 2370180.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Enterprise Metadata Management - Version 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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.