Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Standard Edition & RAC?

Re: Oracle Standard Edition & RAC?

From: Remigiusz Soko?owski <rems_at_wp-sa.pl>
Date: Wed, 03 Jan 2007 08:45:14 +0100
Message-id: <459B5F0A.6050607@wp-sa.pl>


Allen, Brandon wrote:
> On my first (and only, so far) 10g implementation (10.2 on AIX) 7 months
> ago - I convinced my client to purchase the diagnostics pack, but also
> convinced them that we did *not* need the Tuning pack, even though
>

[..]

that is exactly what we did and I agree this is a handy tool (especially for OLTP with many schemas and even more turbulently developed web services connected to it).

The coolest thing IMHO is "Top activity" page with Top10 lists of SQLs and sessions taking the biggest part of DB time. It allows for setting the right diagnosis quickly. Well, I would even state, that worth of the price... especially because using DBA_HIST_% tables is forbidden without the license (as I learnt from this list). I could build such tool on my own, but it would cost more actually and probably would be slower...

And tuning pack is much more controversive - when testing it we allowed to implement one of recommended changes and the result was worse than previously. Certainly it would be useful just to see what it "thinks", but also very dangerous tool to use. And for buy only if one has too much money.

Other modules we tested not but IMHO they are certainly not worth of the price.
Just my 3 cents

Regards
Remigiusz

-- 
---------------------------------------
Remigiusz Sokolowski <rems_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL  v.  4.x
Oracle v. 10.x
---------------------------------------

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 03 2007 - 01:45:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US