RE: Best course to understand why a bad plan is chosen by optimizer

From: Reen, Elizabeth <"Reen,>
Date: Mon, 16 Sep 2019 13:41:57 +0000
Message-ID: <ab230283ecbf4a8c8c0167a0f1467bfe_at_imcnam.ssmb.com>

        Too bad, it was a great class. I really enjoyed it.

Liz

Liz Reen
CPB Database Administration

Dev Servers:  Oracle  |  ORasS  |  Golden Gate  |  Sybase  |  MS-SQL  |  MSaaS  |  Neo4j  |  HBase  -  Prod Servers: Golden Gate  |  Neo4j  |  HBase  - 

ServiceNow  For: Oracle | OraaS | Golden Gate : ICG NA EX US CPB ORACLE APPLICATION DBAS - For Sybase | MS-SQL | Neo4j | HBase: ICG NA EX CPB SYBASE  APPLICATION DBAS

-----Original Message-----

From: [External] oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of [External] Jonathan Lewis Sent: Sunday, September 15, 2019 1:29 PM To: ORACLE-L
Subject: Re: Best course to understand why a bad plan is chosen by optimizer

I used to run a day-long course that would probably have met your requirements. I don't run it any more, but Richard Foote (https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_richardfoote&d=DwIFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=8H-9HLNXeFFwkCmC2OBJ0dBM7zeR4KcRViWSzpui_Ss&s=DOaFJfOffIVD-7SLZIbXdmOZyCdhpP7zO774ekAlSNo&e= ) looks like the next best thing.

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of kunwar singh <krishsingh.111_at_gmail.com> Sent: 13 September 2019 02:43
To: ORACLE-L
Subject: Best course to understand why a bad plan is chosen by optimizer

Hi Listers,
Silly question :)

Is there any Oracle guru who give course on this specific topic and goes much in depth.

Not looking for course on sql tuning. I am able to tune the query in most cases, it is the optimizer decisions for many queries in a new version upgrade(11g to https://urldefense.proofpoint.com/v2/url?u=http-3A__12.1.0.2&d=DwIFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=8H-9HLNXeFFwkCmC2OBJ0dBM7zeR4KcRViWSzpui_Ss&s=gVWRB7gHtEsW7WZarSQ_eenve1lt65Q_vAWLntjhXts&e= ).. which are giving me some headaches as many applications we support generate queries dynamically and statistics optimization is the farthest i am able to go to get good plans. Cannot use SPM options due to dynamic nature of sqls generation.

--

Cheers,
Kunwar
--

https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwIFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=8H-9HLNXeFFwkCmC2OBJ0dBM7zeR4KcRViWSzpui_Ss&s=SdJbYIaBqZQn154rGd9Wh8jfFfT-DkNmCYUlXJt7aVc&e=

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 16 2019 - 15:41:57 CEST