RE: oracle monitoring tool and historical data

From: Pete Sharman <>
Date: Tue, 13 Feb 2018 07:51:55 +1100
Message-ID: <01de01d3a443$51c25250$f546f6f0$>

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: [] On Behalf Of Rich J Sent: Tuesday, February 13, 2018 01:23 AM To:
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...  


Received on Mon Feb 12 2018 - 21:51:55 CET

Original text of this message