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.
Pete
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Rich J
Sent: Tuesday, February 13, 2018 01:23 AM
To: oracle-l@xxxxxxxxxxxxx
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...
Rich
