Re: AWR Usage Poll
Date: Thu, 14 Aug 2008 12:37:40 +0100
On Thu, Aug 14, 2008 at 5:38 AM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:
> DBA_FEATURE_USAGE_STATISTICS is the view I believe you're referring to.
> It's interesting though, on my database, I've run awrrpt.sql many times,
> and "Automatic Workload Repository" shows 0 usages. On the same database,
> I've run addmrpt.sql only once, and it shows 1 usage for "Automatic Database
> Diagnostic Monitor". So, I'm not exactly sure what's going on.
> Try this on your database:
> select name, detected_usages from dba_feature_usage_statistics where
> detected_usages > 0;
Then try it on any development databases that you might have cloned from your live system. We don't license development systems for diagnostics and tuning (couldn't make the business case) but do license production systems. That view returns detected usages from before the database was created for us!
> Niall Litchfield
> Oracle DBA