My Oracle Support Banner

Script to cleanup EM_METRIC_ITEMS, EM_METRIC_KEYS, EM_METRIC_STRING_LATEST and MGMT_LONG_TEXT (Doc ID 2759244.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.5.0 to 12.1.0.5.0 [Release 12.1]
Enterprise Manager Base Platform - Version 13.4.0.0.0 to 13.4.0.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

The EM_METRIC_ITEMS, EM_METRIC_KEYS, EM_METRIC_STRING_LATEST and MGMT_LONG_TEXT tables are occupying lots of space in the MGMT_TABLESPACE tablespace.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 IMPORTANT NOTE:
Take an export backup of EM_METRIC_ITEMS, EM_METRIC_KEYS, EM_METRIC_STRING_LATEST and MGMT_LONG_TEXT tables prior to these actions as the data in these tables will be purged.
 
What the script does?
 Steps to change retention from default 24 months to 6 months
 Additional considerations prior to running the script
 Script execution: Temporary run
 Validating temporary run log
 Script execution: Final run
 Validating the final run log

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