Re: SQL Tuning Tool

I like Marcus Moening's "Mumbai" tool. You can download it here:

https://marcusmonnig.wordpress.com/download/

It works only on Winduhs (yeah, I know), but is otherwise an excellent too, at least in my opinion.

Regards

On 11/19/2017 07:39 PM, dba oracle 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
> <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
>
>
>
>
>
>
>
>
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


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