Re: Tuning tools

We also evaluated Quest SQLabXpert (their tuning tool). It was ok, but what it basically did was apply 4 hints to your statement - if you need a tool to do that, then.... LECCO actually re-writes the SQL to identify all possible execution plans. In many cases, we get over 1000 re-writes of the SQL!

Cheers!

"bonminh lam" <mailbox_at_online.de> wrote in message news:39CBA23F.75B19DA4_at_online.de...
> 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.
>
>
Received on Tue Sep 26 2000 - 07:44:19 CDT