Yes, SQL Developer has an interface to the tuning packs’s SQL Tuning Advisor.
But there’s more.
I tried to cover them here:
https://www.slideshare.net/hillbillyToad/tuning-diagnostics-features-in-oracle-sql-developer
autotrace/execution plans
comparing plans
RTSM
ASH/AWR/ADDM
Instance viewer/TopSQL report
From: dba oracle [mailto:iamanoracledba@xxxxxxxxx] ;
Sent: Sunday, November 19, 2017 7:39 PM
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: SQL Tuning Tool
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 HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=http-3A__www.SQLFast.com&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Va4Y7SHr15jme-gdwHoYM-oYt0Bcj3LDzMm4eUGLzYo&s=U1J9b977I8Rgd9jWtGP8NlfqYsCc20SmEPE55M48uZQ&e="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
