OCM 11g Preparation - Interpret execution plan

As the topic before, execution plans are another thing that just the practical experience will give you knowledge. Studying through docs is not a good approach to learn that, at least for me.

After you get the basic concepts, try to check and understand what and why is happening.

Study also:

  • Creating Plan Table.
  • Set explain from SQL*Plus.
  • Explain and get results using DBMS_XPLAN.
  • Dictionary views with Plan information.

Path to Documentation:

Performance Tuning Guide -> 11 The Query Optimizer
Performance Tuning Guide -> 12 Using EXPLAIN PLAN


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.