Re: Tuning tools

You can also check DBPartner from Compuware Numega (http://www.numega.com/products/dbpartner/dbpart.shtml)

DBPartner also rewites the SQL AND it captures all SQL sent by any windows application to an Oracle server (includes dynamic SQL). Regarding the SQL rewrite, DBPartner is also the only one that can be extended by the users. And I don't think that supplying 1,000 new versions is a good thing (who wants to go and look at all of them? that's what the soft is supposed to do!)

But of couse, my opinion is suspect as I am the author of the tuning part (based on the old TunaSQL)

Fernando

<kreitsch_at_my-deja.com> wrote in message news:8qsfo4$he5$1_at_nnrp1.deja.com...
> Hello Lucas:
> at www.quest.com ( go to Spotlight on Oracle )
> Then you can download and executing after getting the key by e-mail.
>
> You have to configure a user 'spot' for example with little tables and
> then the tuning -Trip goes on and poor databases belong to the animals
> who will dy out.
>
> Ok it's not so simple but the tool is fantastic.
>
> /Karl, be blessed.
>
> In article <8qs7k5$oso$1_at_news.ipartners.pl>,
> "Lukasz Feldman" <lukasz_at_atm.com.pl> wrote:
> > Where can I download some demo?
> >
> > Lukasz
> >
> > U¿ytkownik <kreitsch_at_my-deja.com> napisa³ w wiadomo¶ci
> > news:8qq8ge$h6e$1_at_nnrp1.deja.com...
> > > 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.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 27 2000 - 17:44:27 CDT