xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 2) | Tanel Poder Consulting

[utterances-bot]

xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 2) | Tanel Poder Consulting

In the previous post in this series, I showed how my scripts xb.sql and xbi.sql (eXplain Better and eXplain Better, by sqlId) help you see Oracle execution plan details in a more complete way.
Here are the features that I currently plan to cover:
More detailed access/filter predicate info next to plan tree data (Part 1) More intelligent row-source level execution statistics presentation (Part 2, this post) Calculate Optimizer Cost misestimation factor and demo its effects (Part 3, coming soon) More intelligent row-source level execution statistics presentation Look into the following example output by DBMS_XPLAN. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

https://tanelpoder.com/posts/xb-sql-script-explain-oracle-plan-better-part-2/

[robinho848]

How to rerun DML query which includes bind variables and it was run by application user with statistic_all=all

[robinho848]

I tried with the steps as following

• alter session statistic level = all
• run query
• @xb
  This way was ok but I couldn’t use with @xbi sql-id and it didn’t show up full metrics
  Please help to correct me how to use @xbi in this case

Thanks