RE: Alternatives to OEM Diagnostic/Tuning Packs

  • From: Michael Dinh <mdinh@xxxxxxxxx>
  • To: "rodd.holman@xxxxxxxxx" <rodd.holman@xxxxxxxxx>, "Johnson, William L (TEIS)" <WLJohnson@xxxxxx>
  • Date: Thu, 28 Jun 2012 19:28:26 -0700

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@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






From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Rodd Holman [rodd.holman@xxxxxxxxx]
Sent: Thursday, June 28, 2012 7:18 PM
To: Johnson, William L (TEIS)
Cc: Oracle-L@xxxxxxxxxxxxx
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.

On Jun 28, 2012 7:52 PM, "Johnson, William L (TEIS)" <WLJohnson@xxxxxx>
> 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



Other related posts: