Re: SQL Tuning Tool

+1.

And if you don’t have diag pack licenses, the same author has written a freeware ASH alternative which Mumbai can use instead.

Regards

Jo

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virusvrij.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On 24 November 2017 at 03:36, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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. 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
>
>

-- 
mvg/regards,

Jo

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