How to Re-build Index EM_METRIC_ITEMS_PK and EM_METRIC_KEYS_PK (Doc ID 2097818.1)

Last updated on JANUARY 21, 2016

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Goal

Indexes EM_METRIC_ITEMS_PK and EM_METRIC_KEYS_PK have grown large in OEM Repository database.
How to re-build these indexes , so that space can be freed up to tablespace.
 

Solution

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