RE: oracle monitoring tool and historical data

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich J Sent: Tuesday, February 13, 2018 01:23 AM To: oracle-l_at_freelists.org
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  

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