Re: SQL Tuning Tool

Thanks, Stefan. I will try it

Regards,
Wil

2017-11-21 1:46 GMT+11:00 Stefan Koehler <contact_at_soocs.de>:

> 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