This blog post might help you out, too. In EM12c, there is a way to view any
database that you’re monitoring and see what mgmt packs and features you’re
using-
http://dbakevlar.com/2016/02/management-packs-restricted-use-licenses-and-the-enterprise-manager/comment-page-1/
<http://dbakevlar.com/2016/02/management-packs-restricted-use-licenses-and-the-enterprise-manager/comment-page-1/>
My post on information reporting just so happened to focus on feature usage,
too:
http://dbakevlar.com/2013/12/em12c-information-reporting/ ;
<http://dbakevlar.com/2013/12/em12c-information-reporting/>
Hope this helps,
Kellyn
On Nov 16, 2016, at 8:44 AM, Franky Weber Faust <weber08weber@xxxxxxxxx>
wrote:
Hello Jithin,
I don't know any product which monitors that kind of info. I know OEM does
that. Anyway you can query dba_feature_usage_statistics which tracks the
usage of features, but you will have to know which features you can use in
your edition/license. Use as a reference:
https://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC116 ;
<https://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC116>
Hope it helps...
Regards,
Franky Weber Faust
Oracle DBA
Skype: franky.faust
2016-11-16 12:12 GMT-02:00 Jithin Sarath <jithinsarath@xxxxxxxxx
<mailto:jithinsarath@xxxxxxxxx>>:
Hello List,
Over the last year, I have seen LMS Audit coming up a number of time as a
topic of discussion here. It's my turn now :)
We have some ~200 Oracle Databases (mostly 11.2.0.4.x, some 10g & some 11.1).
During the audit, we observed that certain options were found to be in used
while they weren't supposed to.
Digging around , I see that MOS note 1317265.1 provides a
options_packs_usage_statistics.sql that will list the option pack usage on a
per database level and let us keep an eye on things (except in pre 11.2 Dbs,
which I will have to find another way
Before I start coding to make it into a centralized solution, are there
options (products / opensource code / pet project) that does this already?
Monitor a number of databases and store the result at a central location. I
can then have jobs that would send alerts on meeting certain threshold.
Regards, J