Re: SQL Tuning Tool
From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Mon, 20 Nov 2017 07:12:09 -0800
Message-Id: <D3F7CDFA-01D8-4919-9B85-396AF1B22C4E_at_gmail.com>
>> If you prefer a graphical representation of the SQL and it's parts, search for "Visual SQL Tuning" (maybe adding
>> " Kyle Hailey <http://vimeo.com/user4049336>").
>>
>> I like the approach, but have only very limited real world experience in this method.
>>
>> Martin
>>
>> ^∆x
>>
>> On 20 Nov 2017 01:41, "dba oracle" <iamanoracledba_at_gmail.com <mailto: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 <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
>>
>>
>>
>>
>>
>>
>>
>>
>>
Date: Mon, 20 Nov 2017 07:12:09 -0800
Message-Id: <D3F7CDFA-01D8-4919-9B85-396AF1B22C4E_at_gmail.com>
SQLT is provided under My Oracle Support (MOS) Doc ID 215187.1. If you need to engage Oracle Support on a SQL Tuning ticket, most probably you will be asked to provide the output of SQLTXTRACT (a method part of SQLT). Just be aware that SQLT requires installation. If your SQL is custom, consider using SQLd360 instead of SQLT.
> On Nov 20, 2017, at 06:25, Insights <j_akins_at_nc.rr.com> wrote: > > Download SQLT from my Oracle support, and have everyone read the Oracle doc before using. > > Sent from my iPhone > > On Nov 20, 2017, at 8:17 AM, Martin Berger <martin.a.berger_at_gmail.com <mailto:martin.a.berger_at_gmail.com>> wrote: >
>> If you prefer a graphical representation of the SQL and it's parts, search for "Visual SQL Tuning" (maybe adding
>> " Kyle Hailey <http://vimeo.com/user4049336>").
>>
>> I like the approach, but have only very limited real world experience in this method.
>>
>> Martin
>>
>> ^∆x
>>
>> On 20 Nov 2017 01:41, "dba oracle" <iamanoracledba_at_gmail.com <mailto: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 <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-lReceived on Mon Nov 20 2017 - 16:12:09 CET