RE: How to find directive used in execution plan

From: Stefan Koehler <contact_at_soocs.de>
Date: Thu, 17 Mar 2016 12:47:49 +0100 (CET)
Message-ID: <1093246110.48100.1458215269489.JavaMail.open-xchange_at_app01.ox.hosteurope.de>

Hi Yogi,
the EXPLAIN PLAN FOR is not an option as explained in my Tweet?

The test case in my blog post is very simple for demonstration purpose, but you should be able to adapt it to more complex cases as well. Can you please send the CBO trace for verification?

Thanks.  

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK  

> "Tiwari, Yogesh" <Yogesh.Tiwari_at_fidelity.co.in> hat am 17. März 2016 um 07:24 geschrieben:
>
> Thanks Stefan.
>
> I read through your post. It's neat. However, your test case considers a simple eg. In my case, table had 315 directives. While, I went through
> 10053 trace. I found that it evaluates overs 70 dirid. Yet, it didn’t list final 7 directives that it used for the execution plan. That's exactly
> where I got stuck.
>
> Although, upon further investigation, I found that reason for regression was "optimizer_dynamic_sampling" in this db was set to 4. Once I changed
> it to 2, query ran fine.
>
> But, yeah, my question remained unanswered L from 10053 trace.
>
> Maybe I m still missing something?
>
> Thanks,
>
> Yogi | Technical Specialist – Databases | Fidelity International
> FIL India Business Services Private Limited
> 5th Floor, Tower – D, Unitech Cyber Park,
> Sector 39, Gurgaon 122 002, Haryana, India.
> T: +91 124 412 3656 | I: 8 779 3656 | E: yogesh.tiwari_at_fil.com
>
> Disclaimer: The information transmitted is intended for the person or entity to which it is addressed and may contain confidential, privileged or
> copyrighted material or attorney work product. If you receive this in error, please contact the sender and delete the material from any computer.
> Any comments or statements made are not necessarily those of FIL India Business Services Private Limited or any other Fidelity entity. All e-mails
> may be monitored or recorded.

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

Received on Thu Mar 17 2016 - 12:47:49 CET