RE: Alternatives to OEM Diagnostic/Tuning Packs

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Thu, 28 Jun 2012 19:28:26 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B30649BF7A2F49_at_mail02.mba.xifin.com>

If you set control_management_pack_access to NONE; then I think you should be okay. Please correct me if I am wrong here.

I am currently using Ignite, but there are things that OEM can do that Ignite cannot, e.g. create plan baseline from history.

SYS_at_PRIMARY> show parameter manage

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
control_management_pack_access       string                           NONE
resource_manager_cpu_allocation      integer                          24
resource_manager_plan                string
standby_file_management              string                           AUTO
undo_management                      string                           AUTO

SYS_at_PRIMARY> select count(*) from DBA_HIST_ACTIVE_SESS_HISTORY;

  COUNT(*)

---

         0

SYS_at_:PRIMARY> select count(*) from V$ACTIVE_SESSION_HISTORY;

  COUNT(*)

---

         0

-Michael.

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Rodd Holman [rodd.holman_at_gmail.com] Sent: Thursday, June 28, 2012 7:18 PM
To: Johnson, William L (TEIS)
Cc: Oracle-L_at_freelists.org
Subject: RE: Alternatives to OEM Diagnostic/Tuning Packs

That's a good, point. Oracle has a clear document of which tables and views are taboo. Anything "HIST" and a few more are on the list. When researching products such as these, that's always the first question I ask for clarification on. The reason I'm looking at their product is because it's priced better than OEM. But that's only true if it doesn't cause me to license diagnostic and tuning packs due to background hits. At that point there is negative incentive to use their product. --Rodd

On Jun 28, 2012 7:52 PM, "Johnson, William L (TEIS)" <WLJohnson_at_te.com> wrote:
>
> The only thing I worry about with tools like these is that they are
querying tables/views behind the scenes that will end up biting you in an audit. With the introduction of the Diagnostics and Tuning Packs, there are several views/tables in the database that can be queried without any special permission - but they require licensing. I would hate to use a "free" product to only find out it is hitting tables inside the database that will cost you in the event you are audited.
>
> I may be stating something you already know...but better over informed
than burned in an audit...
>
> Bill
>

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


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

Received on Thu Jun 28 2012 - 21:28:26 CDT