RE: SQL Tuning Tool

Then it is the office firewall.

Liz

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Reen, Elizabeth Sent: Thursday, November 30, 2017 9:57 AM To: 'iamanoracledba_at_gmail.com'; Steven Heterogeneous Cc: Karl Arao; oracle-l
Subject: RE: SQL Tuning Tool

            I get a 403 when I try to go to the page.

Liz

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba Wilson Sent: Wednesday, November 29, 2017 11:52 PM To: Steven Heterogeneous
Cc: Karl Arao; oracle-l
Subject: Re: SQL Tuning Tool

Hi Steven,
It looks like we cannot attach any attachment in the list. I've uploaded it in slideshare.

https://www.slideshare.net/WilsonHarawoola/sql-tuning-82947963<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.slideshare.net_WilsonHarawoola_sql-2Dtuning-2D82947963&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=om0NagCtWjtSgb1GXd2JT4lpX14yqGUgVaAOL56FkZc&s=hmYuCm5op7uaQQRsPerQobxO8oXzApWB3ZopSXGehdM&e=>

Regards,
Wil

2017-11-30 12:34 GMT+11:00 dba Wilson <iamanoracledba_at_gmail.com<mailto:iamanoracledba_at_gmail.com>>: Hi Steven,
The PPT is attached.

Alternatively, you can view it in slideshare. https://www.slideshare.net/WilsonHarawoola/sql-tuning-82947963<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.slideshare.net_WilsonHarawoola_sql-2Dtuning-2D82947963&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=om0NagCtWjtSgb1GXd2JT4lpX14yqGUgVaAOL56FkZc&s=hmYuCm5op7uaQQRsPerQobxO8oXzApWB3ZopSXGehdM&e=>

Regards,
Wil

2017-11-29 14:56 GMT+11:00 Steven Heterogeneous <steven.heterogeneous_at_gmail.com<mailto:steven.heterogeneous_at_gmail.com>>: Hi Wil,

Do you mind share a copy of your PPT to us?

Thanks,
Steven

On Mon, Nov 27, 2017 at 8:52 AM, dba Wilson <iamanoracledba_at_gmail.com<mailto:iamanoracledba_at_gmail.com>> wrote: 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<mailto: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<https://urldefense.proofpoint.com/v2/url?u=http-3A__bit.ly_2B6Ysv0&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=om0NagCtWjtSgb1GXd2JT4lpX14yqGUgVaAOL56FkZc&s=i0GpvL0pzSyPGnMTLRzsSNqyO2VEprnYUobT1OK1I9o&e=> (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<https://urldefense.proofpoint.com/v2/url?u=http-3A__bit.ly_2A9mSoA&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=om0NagCtWjtSgb1GXd2JT4lpX14yqGUgVaAOL56FkZc&s=UR1mvty5DmB2LlLGViuX9U718ul7DPCgx5OU5xnjmtU&e=> (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<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<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.SQLFast.com&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=om0NagCtWjtSgb1GXd2JT4lpX14yqGUgVaAOL56FkZc&s=v1DZvZI3UdB8X02FB5qirAeRGHVhvG6FmAXkqLuzUq4&e=>. 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<https://urldefense.proofpoint.com/v2/url?u=http-3A__karlarao.wordpress.com&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=om0NagCtWjtSgb1GXd2JT4lpX14yqGUgVaAOL56FkZc&s=jyVSAXln3dWPLfsL9YTvGKkSMnvQhaEZ9xq3t3tsaUI&e=> Wiki: karlarao.tiddlyspot.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__karlarao.tiddlyspot.com&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=om0NagCtWjtSgb1GXd2JT4lpX14yqGUgVaAOL56FkZc&s=d49jNti9Vi-dSqsIFg9uGNFt3Z3L_keVgkw1BCyN6Fs&e=> Twitter: _at_karlarao<https://urldefense.proofpoint.com/v2/url?u=http-3A__twitter.com_karlarao&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=om0NagCtWjtSgb1GXd2JT4lpX14yqGUgVaAOL56FkZc&s=I0OG1kSkDtAeZ8Gv9tb4PnpPgWsZjvEIFLDRBbMPr-E&e=>

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 30 2017 - 22:14:34 CET