Re: Tracking Oracle Option Pack Usage

If you have an Oracle Enterprise Manager 12c or later installation then the tracking functionality is built in (though not hugely friendly to setup or use). Look for usage tracking reports in the documentation. As I said not hugely friendly (requires sysdba, outputs csv) the big advantage is that it should be using the same logic that the LMS scripts use - indeed it should be possible for LMS to accept such reports as evidence of your usage.

On 16 Nov 2016 14:15, "Jithin Sarath" <jithinsarath_at_gmail.com> wrote:

> 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