RE: AWR Licensing
- From: Pete Sharman <peter.sharman@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Jul 2004 03:36:34 +1000
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
