Re: Tuning tools

Hello!

I made best expieriences with Spotlight on Oracle ( Quest Software ) . For Instance-Tuning and for SQL-Tuning.
You can fast idnetifiy instance-Bottlenecks and poor sql-STMT The best GUI for DatabaseTools i ever seen. The Tool is not so good for backround-Tuning!

/Karl

In article <39CBA23F.75B19DA4_at_online.de>,   no_spam_at_bmlam.de wrote:
> Thanks for your input so far.
>
> Just found out the Quest Software, the vendor which brought out
 T.O.A.D, also
> has a tuning module. Any experience with that?
>
> "Darren M." schrieb:
>
> > We are very impressed with LECCO SQL Expert. It identifies poor SQL
 by
> > looking at the SGA and by scanning through source code (stored
 objects, VB,
> > Forms, JAVA, etc.) and extracting SQL. It also identifies all
 execution
> > plans for the SQL to be tuned, and allows you to test them to find
 the best
> > one. I believe you can download a trial copy at www.leccotech.com .
> >
> > -Darren
> >
> > "bonminh lam" <mailbox_at_online.de> wrote in message
> > news:39C55C23.FA0D2E75_at_online.de...
> > > Our company is looking into getting some tuning tools for the
 Oracle
> > > databases. I am wondering what products are there on the market
 and what
> > > strength they have and what experience people have made. I
 understand
> > > Oracle itselfs offers Oracle Expert, but Platinum, BMC and
 Compuware
> > > also have some competitive products.
> > >
> > > I would appreciate you you drop some lines regarding your
 experience
> > > with these products.
> > >
> > > Thanks
> > >
>
> --
> To reply to me via email, please substitute the text no_spam with
 mailbox in
> the return address.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 26 2000 - 08:31:57 CDT