My Oracle Support Banner

Grid Control Repository: Everything you Wanted to Know About Partition Maintenance of Metric Data in the 10g/11g Repository (Doc ID 456101.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Enterprise Manager Base Platform - Version to [Release 10.1 to 11.1]
Information in this document applies to any platform.


The purpose of this document is to provide the steps needed to perform partition maintenance for the metrics data in the Grid Control repository as well as explain the current known issues and workaround/solutions available. 


The bulletin is intended for experienced Grid Control administrators. It covers both 10gR1, 10gR2 and 11gR1 versions. The scope of this document is to cover only the partitions created for Metric related data in the Repository. There are other tables for example, related to Auditing which are also partitioned, which is not covered in this document.


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
 Background Information
 Steps to Perform Partition Maintenance
 1. Check That The Necessary Tables Are Partitioned
 2. Apply Fixes For Known EM / Database Bugs
 3. When Is The Maintenance Taking Place Automatically?
 4. When Should the Maintenance be Performed Manually?
 How to Verify that the Partition Maintenance is Successful?
 Known issues

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