RE: AWR Usage Poll
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "pythianbrinsmead@xxxxxxxxx" <pythianbrinsmead@xxxxxxxxx>, "piontekdd@xxxxxxxxx" <piontekdd@xxxxxxxxx>
- Date: Thu, 14 Aug 2008 00:38:47 -0400
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;
-Mark
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
Of Mark Brinsmead [pythianbrinsmead@xxxxxxxxx]
Sent: Wednesday, August 13, 2008 9:41 PM
To: piontekdd@xxxxxxxxx
Cc: oracledbaquestions@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: AWR Usage Poll
Not sure whether there is a flag specifically for AWR, but such flags do,
indeed, exist. If there is one (or more) for AWR, I'm not sure how
comprehensive it is. After all, you require special licensing to select
certain rows (but not others!) from certain dictionary views.
These "flags" are visible through a dictionary view. DBA_FEATURES_USED?
V$FEATURES_USED? Something like that...
On Wed, Aug 13, 2008 at 6:27 PM, Bradd Piontek
<piontekdd@xxxxxxxxx<mailto:piontekdd@xxxxxxxxx>> wrote:
It may be installed by default, and you can't really not install it (in 10g),
but you are supposed to license the Diagnostics Pack to use AWR , awrrpt , etc.
I had heard there was an internal flag that was set as soon as you used part of
its functionality in case oracle wanted to audit your database, not sure if
that was urban legend.
Bradd Piontek
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
On Wed, Aug 13, 2008 at 7:21 PM, Dba DBA
<oracledbaquestions@xxxxxxxxx<mailto:oracledbaquestions@xxxxxxxxx>> wrote:
What do you mean by separately licensed product? I use it in every product. Its
installed by default with the enterprise edition version. I did not know there
was a separate license.
On Wed, Aug 13, 2008 at 6:18 PM, Jared Still
<jkstill@xxxxxxxxx<mailto:jkstill@xxxxxxxxx>> wrote:
I am curious about the acceptance and usage of AWR (Active Workload Repository)
This has been around a few years now, and I see some bits of conversations
where the assumption is made that AWR is available when troubleshooting a
problem.
Such is not always the case however, as AWR is a separately licensed product.
Don't forget, ASH (Active Session History) is also part of AWR, and subject
to the same licensing restrictions.
Which brings me to the poll.
http://www.misterpoll.com/polls/352785
This should take a couple of minutes at the most, as there are only
10 multiple choice questions. There is room for a written response to many
of the questions as well, should you feel the need to embellish.
This poll is open until 8/31/2008. It is set to a maximum of 500 responses,
which is probably sufficient.
Thanks!
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
Cheers,
-- Mark Brinsmead
Senior DBA,
The Pythian Group
http://www.pythian.com/blogs
--
//www.freelists.org/webpage/oracle-l
Other related posts:
