RE: AWR Licensing

  • From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 27 Jul 2004 12:06:36 -0700 (PDT)

Pete,
Thanks for the information.

I wasn't planning on turing off anything, just curious, and preparing for Dgmt 
questions
as we work on next year's virtual budgets :) 

Cheers!

- Kirti 

 
--- Pete Sharman <peter.sharman@xxxxxxxxxx> wrote:
> Kirti
> 
> I would actually strongly suggest NOT turning it off.  Reason is that the f=
> ree management stuff with 10g (and there is a LOT of that by the way) also =
> uses it.  Having said that, the stats collection is instrumented into the k=
> ernel and has its own self throttling mechanism, so the performance impact =
> is minimal.  So unless you're running a TPC-C benchmark, don't worry about =
> it.
> 
> The only documented way of turning it off that I'm aware of - if you are si=
> lly enough to do that ;) - is changing STATISTICS_LEVEL, which also turns o=
> ff a lot of the free stuff.
> 
>  =
> 
> Pete
>  =
> 
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
>  =
> 
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long-term Oracle DBA
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] =
> On Behalf Of Kirtikumar Deshpande
> Sent: Wednesday, 28 July 2004 1:26 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: AWR Licensing
> 
> Pete,
> Just curious... =
> 
> 'cause I fall in that poor individuals category... =
> 
> 
> If I don't have a Diagnostics Pack license, am I allowed to use the AWR pac=
> kage, just
> once, to turn the AWR stuff off? If I can't access all that nifty informati=
> on without
> Diag Pack, why would I want Oracle10g run those snapshots? =
> 
> 
> Regards,
> 
> - Kirti =
> 
> 
>


                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: