Tracking Oracle Option Pack Usage
Date: Wed, 16 Nov 2016 19:42:51 +0530
Message-ID: <CACoevcqyPjHpwR8MxKjdsOfnyuZOZhmpHTVLKK0ft7gTkvSSwg_at_mail.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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 16 2016 - 15:12:51 CET