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 -----------------------------------------------------------------