OEMM Database Maintenance Task Not Running or Running Very Slow

(Doc ID 2370180.1)

Last updated on MARCH 08, 2018

Applies to:

Oracle Enterprise Metadata Management - Version 12.2.1.1 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

 

Cause

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