Re: SQL Tuning Tool

Hi Guys,

Thanks for your valuable input. I am downloading and to study Mumbai. Hope it is a "developer-friendly" tool. lol

Regards,
Wil

2017-11-24 22:47 GMT+11:00 Karl Arao <karlarao_at_gmail.com>:

> my tools I always use for SQL tuning/troubleshooting:
>
> sqld360 (Mauro Pagano) - every information about the SQL_ID in one shot
> db optimizer (Kyle Hailey) - for realtime profiling and query diagramming
> (Visual SQL Tuning/breaking down the logic behind the SQL) - I'm a very
> visual guy
> planx http://bit.ly/2B6Ysv0 (Carlos Sierra) - if I can't get sqld360, I
> need to have this. it's like my text version of sqld360
> sql monitor - if I can't have sqld360 and planx, at least I must have this
> sql developer - the newest version has the plan_line_id on exec plan
> useful for troubleshooting on 11.2/11.1 DBs
>
> one example how I use some of the tools above together to troubleshoot a
> SQL - http://bit.ly/2A9mSoA (correlating through plan_line_id and
> drilling down on business logic w/ VST)
>
>
>
> -Karl
>
>
>
>
> On Sun, Nov 19, 2017 at 7:39 PM, dba oracle <iamanoracledba_at_gmail.com>
> wrote:
>
>> 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. 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> --
> Karl Arao
> Blog: karlarao.wordpress.com
> Wiki: karlarao.tiddlyspot.com
> Twitter: _at_karlarao <http://twitter.com/karlarao>
>

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