Re: AWR Usage Poll

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: Mark.Bobak@xxxxxxxxxxxx
  • Date: Thu, 14 Aug 2008 12:37:40 +0100

On Thu, Aug 14, 2008 at 5:38 AM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>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

> --
> Niall Litchfield
> Oracle DBA

Other related posts: