Re: How to purge metric values from dropped metric extension in EM13c?

Have you looked at the SYSMAN MGMT_METRICS tables.

There's a METRIC_GUID (but perhaps it got removed as well?). I would think you'd be able to manually do either:

1. Delete the mgmt collected metrics from the SYSMAN schema in the repository
2. Save the metrics you want to keep to a temp table, truncate the metrics table(s) and reinsert the saved values

OEM would need to be down while you did that though. Purging data manually from the SYSMAN tables is pretty straight forward once you have the METRIC_GUID and find all the child tables that also have that GUID.

Chris

On Mon, Oct 29, 2018 at 9:38 AM Rich J <rjoralist3_at_society.servebeer.com> wrote:

> Hey all,
>
> In EM13cR2, I had a metric extension (ME) that collected roughly 28M
> values. As it was causing major performance issues in EM, I undeployed it
> from all targets, exported the ME, and dropped it. That's fine, except all
> of the collected values were not also dropped, but cannot now be easily
> reported on, either. That's fine, as I don't need them, but how does one
> go about purging those values? As the collected values are strings, they
> take up the majority of my EM repository, and likely will for the next two
> years.
>
> Searching MOS, but I haven't found anything yet. Anyone?
>
> TIA!
> Rich
>

--
http://www.freelists.org/webpage/oracle-l