SkillBuilders Welcome  |  Log in
All Oracle Tutorials

How to Read an Execution Plan in Oracle

Oracle Consultants Available

In this free tutorial you will learn how to generate and read (interpret) an execution plan in Oracle Databases.

Understanding what the Oracle Database does with your SQL is essential to tuning - and the execution plan is the key.  

Oracle Certified Master DBA John Watson will provide a brief introduction (4 minutes) - which includes John's tuning methodology, then demonstrate EXPLAIN PLAN, SQL*Plus AUTOTRACE and DBMS_XPLAN.DISPLAY_CURSOR.  In the demonstration, John will teach you:

  • How to read an execution plan
  • Find the 1st step in the plan
  • Decipher the order of the steps in the plan
  • That EXPLAIN PLAN can be very misleading 

Prerequisites: To get the most from this tutorial, you should:

  • Know how to code SQL
  • Be familiar with SQL*Plus
  • Know - in very general terms - what an execution plan is. 
  • Have a basic understanding of the Library Cache (this is where Oracle Database stores parsed SQL statements)
  • Have a basic understanding of the Cost Based Optimizer (this is the part of the database that parses your SQL, creates an execution plan.  Hopefully the correct - most efficient - plan).

Next Step:  12c Adaptive Execution Plans and 12c Re-Optimization of Execution Plans

 

Feb 6 - Oracle SQL Tuning - Core Skills for Beginners

  • How to read an Oracle Database SQL Execution Plan   (13:139)   (click to read the Transcript)

    Date: Mar 30, 2014

    View video now - Free Online Registration required

    Here is a preview:

    NOTE: Some corporate firewalls will not allow videos hosted by YouTube.

    To take a class with John, visit our Oracle SQL Tuning Class.