|
[oracle-l]
||
[Date Prev]
[01-2007 Date Index]
[Date Next]
||
[Thread Prev]
[01-2007 Thread Index]
[Thread Next]
Re: Oracle Standard Edition & RAC?
- From: Remigiusz Soko?owski <rems@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 03 Jan 2007 08:45:14 +0100
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@xxxxxxxx>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v. 4.x
Oracle v. 10.x
---------------------------------------
--
http://www.freelists.org/webpage/oracle-l
|
|
