Explain the Explain Plan – Part 3 of Optimizer Workshop

Examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan.

  • Version
  • Download 116
  • File Size 33.11 MB
  • File Count 1
  • Create Date October 13, 2020
  • Last Updated October 13, 2020

Explain the Explain Plan - Part 3 of Optimizer Workshop

Part 3 of the workshop examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

More information on displaying and reading execution plans can be found in my previous blog posts on DBMS_XPLAN.DISPLAY_CURSOR and using SQL Monitor. Or in the white paper Explain the Explain Plan.

Leave a Reply

Your email address will not be published. Required fields are marked *