Re: Please, question about the license to use DBA_HIST_SNAPSHOT in standard edition

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Thu, 25 Jun 2015 08:16:15 -0600
Message-ID: <558C0D2F.6030605_at_gmail.com>

I STRONGLY encourage anyone who wants to look at 'Enterprise Manager' views and tables to look at the EM licensing document at http://docs.oracle.com/cd/E24628_01/doc.121/e24474/ch2_db_mgmt.htm#OEMLI113 (or, if you really want, the 11g EM license manual is at http://docs.oracle.com/cd/E11857_01/license.111/e11987/toc.htm)

Note that the Management Packs are controlled by the EM license and not by the DB (or WebLogic, Apps, GoldenGate ...) license.

In chapter 2, we read

"These management packs can be purchased only with Enterprise Edition. The features in these packs are accessible through Oracle Enterprise Manager Database Control and Oracle Enterprise Manager Grid Control, and APIs provided with Oracle Database software."

In other words, not available for Standard Edition.

The views you are looking at are, as you say, useless in Standard Edition.

/Hans

On 25/06/2015 7:23 AM, Juan Carlos Reyes Pacheco wrote:
> Hello,
> I was reading there is license for some views in 11g standard edition.
>
> "All data dictionary views beginning with the prefix DBA_HIST_ are
> part of this pack, along with their underlying tables, except for
> these views that you can use without the Diagnostic Pack license:
> DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE, DBA_HIST_SNAP_ERROR,
> DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ, and DBA_HIST_UNDOSTAT."
>
> But in the other hand, apparently is impossible load them.
> https://community.oracle.com/message/10140463
>
> Does any one know what option can be used in standard edition without
> enabling CONTROL_MANAGEMENT_PACK_ACCESS.
>
> Thank you :)

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 25 2015 - 16:16:15 CEST