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@xxxxxxxxx> 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
