RE: AWR Licensing

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 =



--- Pete Sharman <peter.sharman@xxxxxxxxxx> wrote:
> Statspack?  Sure, still being enhanced for those poor individuals who can=
't=3D
>  afford the diagnostics pack.  ;)
> =

>  =3D
> =

> Pete
>  =3D
> =

> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
>  =3D
> =

> "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=
] =3D
> On Behalf Of Jared Still
> Sent: Tuesday, 27 July 2004 3:12 PM
> To: Oracle-L Freelists
> Subject: RE: AWR Licensing
> =

> On Mon, 2004-07-26 at 20:11, Pete Sharman wrote:
> > No question about it at all.  Read the licensing doc, you'll find it sp=
el=3D
> t =3D3D
> > out in black and white.  AWR, ADDM, all the PL/SQL AND data dictionary =
vi=3D
> ew=3D3D
> > s associated with them should only be accessed if you have the diag pac=
k =3D
> li=3D3D
> > cense.
> > =3D
> =

> =

> I see that all the SP stuff is still in $OH/rdbms/admin.
> =

> Is it still officially supported as of 10g?
> =

> Jared
> =

>


                =

__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: