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