+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact

    Free Oracle APEX Tutorials

    • Home
    • All courses
    • Free Oracle APEX Tutorials
    • How to Read a SQL Execution Plan in Oracle – Free Tutorial

    How to Read a SQL Execution Plan in Oracle – Free Tutorial
    Duration: 14 minutes

    John Watson
    Free Oracle APEX Tutorials, Free Oracle DBA Tutorials, Free Oracle Developer Tutorials

    No reviews yet.
    Free
    • Description
    • Lessons
    • Topic Summary
    • Instructors
    • Reviews

    Reading Execution Plans is a Required Prerequisite to SQL Tuning!

    In this free tutorial you will learn how to generate and read (i.e. 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

    Need Help? Call us! 1-401-783-6172

  • Call 1-401-783-6172 for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

  • No Events Scheduled at this time. Call +1-401-783-6172 or email us to schedule this class.
    • Share:
    • 0/1

      • Lecture1.1
        How to read an Oracle Database SQL Execution Plan
        Preview
        14m
    John Watson
    https://skillbuilders.com/our_team/john-watson/

    Please take this tutorial in order to review.

    No reviews yet.

    • Description
    • Curriculum
    • Topic Summary
    • Instructors
    • Reviews
    Free

    You May Like

    How to Tune SQL Joins in Oracle Database – Free Tutorial Read More
    John Watson

    How to Tune SQL Joins in Oracle Database - Free Tutorial

    Free
    Oracle Indexes: Myths, Tips and Tricks – Free Tutorial Read More
    John Watson

    Oracle Indexes: Myths, Tips and Tricks - Free Tutorial

    Free

    Recommended Courses

    • Oracle SQL Tuning – Core Skills for Beginners
       5/5 (1)
      John Watson
    • Oracle SQL Tuning for Developers and DBAs
       4.8/5 (18)
      John Watson
    • How to Tune SQL Joins in Oracle Database – Free Tutorial
      No reviews yet.
      John Watson
    • Introduction to Oracle SQL Tuning for Beginners – Free Tutorial
      No reviews yet.
      John Watson
    • Oracle Indexes: Myths, Tips and Tricks – Free Tutorial
      No reviews yet.
      John Watson
    • Oracle Tutorial – B-Tree Indexes: What, Why and More
      No reviews yet.
      John Watson
    • Oracle SQL Tuning with Explain Plan
      No reviews yet.
      John Watson
    • Oracle SQL Tuning for Beginners Free Tutorial
      No reviews yet.
      John Watson
    • Oracle Database SQL Tuning with Constraints
      No reviews yet.
      John Watson
    • Oracle Database Performance Tuning Workshop
       4.9/5 (6)
      John Watson

    Featured Courses

    Oracle RAC and Grid Infrastructure Administration Fast Track Training

    March 1, 2021
    $5,000.00

    Oracle PL/SQL Programming Workshop

    March 1, 2021
    $2,700.00

    Intermediate Oracle Application Express (APEX) Training

    March 1, 2021
    $2,700.00

    Oracle Database Administration Workshop Level 2

    March 8, 2021
    $3,200.00

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.

    Register for this Class
    • Please enter a number from 2 to 5000.