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_at_ORACLE.COM> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] =
> On Behalf Of Kirtikumar Deshpande
> Sent: Wednesday, 28 July 2004 1:26 AM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 27 2004 - 14:04:03 CDT
