Re: SQL Tuning Tool

From: Mauro Pagano <mauro.pagano_at_gmail.com>
Date: Mon, 20 Nov 2017 20:32:28 +0100
Message-Id: <CD879211-CA09-485E-AFD8-DC5BF0F22453_at_gmail.com>



I do!
I may sound biased but the tool was designed with “ease of consumption” in mind (granted SQL tuning isn’t a trivial topic), worth a shot imho considering it’s completely free. I do take payments in beers though :-)

> On Nov 20, 2017, at 7:35 PM, Andy Klock <andy_at_oracledepot.com> wrote:
> 
> +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
Received on Mon Nov 20 2017 - 20:32:28 CET

Original text of this message