Re: The best performance tools??

[Quoted] Thanks Daniel,

    I'm inclined to agree with your impression of tools on the market, but [Quoted] they still make a lot of money selling them, so there must be something to [Quoted] them. I never have touched most of the GUI tools available, even from Oracle. Still, I have to wonder what I'm missing.

[Quoted] [Quoted] "DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E244B67.CE093DEE_at_exesolutions.com...
> Ivan Oss wrote:
>
> > Hi,
> >
> > I'm new to this newsgroup. I've been an Oracle DBA for 7 years and
currently
> > manage a small database team, so maybe I can contribute. Hopefully I'm
not
> > starting off to heavy for anybody, but I'm already on a mission.
> >
> > I'm looking for the best-of-breed tools for SQL tuning, RDBMS tuning,
> > storage tuning... whatever. I don't care if the vendor is a
fly-by-night or
> > a market leader with a comprehensive product suite. If you have
experience
> > with a tool you think is good, I'd like to hear from you.
> >
> > I'll compile a full list based on the responses I get and post it. Lets
> > hear your votes!
>
> For SQL tuning I've yet to find anything better than the combination of
Explain
> Plan and TKProf. Maybe I'm wrong but my impression of the "tools" out
there is
> that all they are is a wrap of a GUI around the functionality already in
the
> database.
>
> For tuning procedures, packages, and functions I've yet to see anything
that
> does as well as DBMS_PROFILER. Once again a built-in that costs no money
and
> Tom Kyte has an excellent write-up on it in his book "Expert one-on-one
> Oracle".
>
> Storage tuning? I'm not sure to what you are referring? If you mean
running out
> of space ... a combination of DBMS_JOB, a proc, and UTL_SMTP will do
anything
> required. If you are talking about I/O that really needs to be done in the
> operating system and the best-of-breed tool is operating system dependent.
>
> Daniel Morgan
>
>
>
Received on Wed Jan 15 2003 - 06:47:50 CET