Re: AWR Usage Poll

From: Niall Litchfield <>
Date: Thu, 14 Aug 2008 12:37:40 +0100
Message-ID: <>

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

Received on Thu Aug 14 2008 - 06:37:40 CDT

Original text of this message