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 >