Re: SQL Tuning Tool

+1 on SQLd360

Plus, Mauro hangs out here too :)

On Mon, Nov 20, 2017 at 10:07 AM, Carlos Sierra <carlos.sierra.usa_at_gmail.com
> wrote:

> List,
>
> I agree with Stephan: SQL Tuning requires a good understanding of what
> goes on.
>
> These days I use SQLd360 (by Mauro Pagano) every single day. With it I can
> easily visualize things like: performance of multiple execution plans for
> the same SQL, data distribution as per CBO Histograms, history of values
> for binds, where in a plan most time is spent, and many more.
>
> The two main reasons I use SQLd360 as my core SQL Tuning tool are:
>
> 1. Installs nothing on the database
> 2. It is free (you do have to have Tuning or Diagnostics Pack Licenses to
> get the best of this tool although)
>
> Cheers — Carlos
>
>
>
>
> > On Nov 20, 2017, at 06:46, Stefan Koehler <contact_at_soocs.de> wrote:
> >
> > Hello Wil,
> > I have to mention (free) SQLd360 by Mauro Pagano as this is the tool
> that I use all the time: https://github.com/mauropagano/sqld360
> >
> > ... and then train your developers and DBAs in SQL tuning - especially
> in understanding what has gone wrong and how to avoid these issues in the
> future ...
> >
> > IMHO all of these "automatic" tuning and analysis tools suck most of the
> time - especially if you just blindly follow and implement their suggestion
> without understanding the root cause.
> >
> > P.S.: I can only agree with what Dominic wrote/said.
> >
> > Best Regards
> > Stefan Koehler
> >
> > Independent Oracle performance consultant and researcher
> > Website: http://www.soocs.de
> > Twitter: _at_OracleSK
> >
> >> dba oracle <iamanoracledba_at_gmail.com> hat am 20. November 2017 um
> 01:39 geschrieben:
> >>
> >> Hi Gurus,
> >>
> >> I am currently looking for a SQL Tuning tool can be used by DBA as well
> as developers. The background is that we have many complex SQLs being
> developed in our products, each developer may touch those SQLs and change
> them if he/she is handling a ticket related to them. Every change might
> cause performance changing (and actually they did). We want to find a tool
> can be easily used by the developers, and then give them a training
> session, they will be able to tune their new developed/changed SQL before
> tagged to the release.
> >>
> >> I've tried SQL developer. It just simply give us the chance to use SQL
> Advisor.
> >> I also tried Toad, it more looks like an offline SQL advisor. And it
> has crashed several times in my Win 10. It is really frustrating.
> >> I also found this tool, SQLBooster, from [www.SQLFast.com](http://www.
> SQLFast.com). It's cool because it can brake the complex SQL down to
> small queries to analyze the bottleneck. But there is only a few documents
> provided in the website and the UI is not so friendly. I am still
> struggling on testing it.
> >>
> >> Do you guys have any recommendation?
> >>
> >> Regards,
> >> Wil
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l