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 --------------------------------------- -- //www.freelists.org/webpage/oracle-l
