Re: Tracking Oracle Option Pack Usage

_at_Niall, Franky & Kellyn, Thank you for your inputs. I see that EM 12c would make this easy, but I have a strong feeling that I would be asked to do without cost. EM 12c may be free to use for an Oracle customer, but it does require an application and DB server, which I might not get. I'll definitely pitch the idea and see how it goes.

If EM 12c isn't and option, I would probably use a scrap DB as a repository and have a script pull data from DBA_FEATURE_USAGE_STATISTICS. Any thoughts?

_at_Scott: Entitlement is a totally different ball game. If you are clear on what you are entitled, the you can store this in a table and have custom reports generated to compare between usage and entitlement. If you have recently undergone an LMS audit, you'd know what is your entitlement.

Regards, J

On 16 November 2016 at 21:30, Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com> wrote:

> 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/
>
> My post on information reporting just so happened to focus on feature
> usage, too:
> http://dbakevlar.com/2013/12/em12c-information-reporting/
>
> Hope this helps,
> Kellyn
>
> On Nov 16, 2016, at 8:44 AM, Franky Weber Faust <weber08weber_at_gmail.com>
> 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
>
> Hope it helps...
>
> Regards,
>
> Franky Weber Faust
> Oracle DBA
> Skype: franky.faust
>
> 2016-11-16 12:12 GMT-02:00 Jithin Sarath <jithinsarath_at_gmail.com>:
>
>> 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
>>
>
>
>

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