RE: Alternatives to OEM Diagnostic/Tuning Packs
- From: "Johnson, William L (TEIS)" <WLJohnson@xxxxxx>
- To: "rodd.holman@xxxxxxxxx" <rodd.holman@xxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 28 Jun 2012 20:51:58 -0400
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
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Rodd Holman
Sent: Thursday, June 28, 2012 8:29 PM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Alternatives to OEM Diagnostic/Tuning Packs
We have the same issue with OEM. We went with Ignite for a couple of
SQLServer instances and I am very pleased. It has some good reports with
drill down and knowledge base suggestions.
I am now recommending it for some of the Oracle instances. The pricing is
higher for Oracle, but still WAY below the Arm+Leg+First Born that Oracle
wants for their product.
Ignite is also brain dead simple to install. In less than 4 hours I
downloaded CentOS 6.2 x64 DVD iso, created a VMWare 8 VM, downloaded
Ignitefree, ran the installer.sh script, started the monitor with
startup.sh and started monitoring 4 oracle db's.
I created the repository db in an existing sqlserver instance which was
created as part of installer.sh (no special configuration required).
All of this is legally no cost! For full functionality, you need to by the
pay version, but the free version is quite good too.
Compare this to weeks of document reading, patch getting, license
deciphering, and general hair pulling with OEM. Exactly what counts as a
processor? Core? How many users? What type. ARRGGH!
I'm pushing to get this full version for all of our production db's. I can
proactively use the free version on our developement systems to help
diagnose stuff before it goes live.
--Rodd Holman
On Jun 28, 2012 6:43 PM, "Jared Still" <jkstill@xxxxxxxxx> wrote:
>
> On Thu, Jun 28, 2012 at 4:33 PM, D Kenl <dkenlwork@xxxxxxxxx> wrote:
> > * Embarcadero DB Performance Center XE (with DB Optimizer)
> >
>
...
> At a previous employer the oracle packs were 100k plus maintenance.
>
...
>
> Jared
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
