More importantly, from a licensing perspective, if the data is in views/tables
in the EM repository that form part of any pack, ANY tool (including SQL*Plus)
cannot select from those objects without violating the licensing.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Rich J
Sent: Tuesday, February 13, 2018 01:23 AM
Subject: Re: oracle monitoring tool and historical data
On 2018/02/12 01:26, Ls Cheng wrote:
I meant Oracle Configuration Management Pack
If you're looking to report on database configuration, you could roll your own
with Oracle EM and no extra licenses. I don't think that storing multi-value
configuration data lends itself well to custom metrics ("Metric Extensions" in
EM-speak), which are geared towards single values, but I do something similar
to store our RMAN logs in EM. It's done using a simple SQL statement.
Reporting is another matter (a limited-license of Oracle BI is included, if
you're keen to running reports from there), but it works for me.
Perhaps not the best fit, but maybe worth looking into anyway...