Re: Is AWR report on Oracle 11gR2 SE (dev database) reliable, and is it supported?

  • From: Pradeep Chetal <chetal@xxxxxxxxx>
  • To: Mark Brinsmead <pythianbrinsmead@xxxxxxxxx>
  • Date: Tue, 22 Mar 2011 21:45:41 -0400

Thanks. I was told that

  >> control_management_pack_access is set to at least DIAGNOSTICS

Appreciate the feedback. Will use STATSPACK.

-- Pradeep

On Tue, Mar 22, 2011 at 8:39 PM, Mark Brinsmead
<pythianbrinsmead@xxxxxxxxx>wrote:

> never say "never" i suppose, but i too have never heard of oracle
> selling lisenses for oem packs on se.
>
> but then, they are not crazy either.  if you happen to have a large
> deal in the works (e.g. 5 or 10 millions worth of exadata) and say you
> wont sign the deal without diagnostics pack licenses for se, you might
> be amazed at how flexible things can be.  (or not.  i have never been
> positioned to try this myself.)
>
> under the standard OLSA, by which most of us mere mortals have to
> live, AWR is simply unavailable for SE.  happily statspack still
> exists.  it is not as cool, but it gets the (basic) job done.
>
>
> On Tuesday, March 22, 2011, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>
> wrote:
> >
> >
> >
> >
> >
> >
> >
> >
> > I’m not sure if it’s reliable or supported, but I don’t think it’s legal
> to use AWR on SE since AWR requires the Diagnostics Pack and the Diagnostics
> Pack license
> >  is only available for EE unless that has changed.  I have heard stories
> before about Oracle selling Diagnostics Pack licenses for SE when pressed on
> the issue, but when I asked Oracle Sales about it, I was told it wasn’t an
> option.  That was a couple years
> >  ago though.
> >
> > Regards,
> > Brandon
> >
> >
> >
> >
> >
> > Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> >  and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
> >
> >
> >
> >
>
> --
> Cheers,
> -- Mark Brinsmead
>   Senior DBA,
>   The Pythian Group
>   http://www.pythian.com/blogs
>

Other related posts: