+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
    • Oracle SQL Tuning with Explain Plan

    Oracle SQL Tuning with Explain Plan
    Duration: 60 minutes

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

     5/5 (1)
    Free
    • Description
    • Lessons
    • Topic Summary
    • Instructors
    • Reviews

    Do you use EXPLAIN PLAN to tune Oracle SQL? Does it always “tell the truth”, or does it “lie”. (Maybe it’s not the whole truth!) In this free tutorial from SkillBuilders’ Oracle Certified Master John Watson, you will learn why the execution plan generated by EXPLAIN PLAN can be misleading and what to do about it. After a brief lecture, John demonstrates exactly why. You’ll hear about dynamic sampling, adaptive cursor sharing (11g), adaptive execution plans (12c) and of course, bind variables. John demonstrates how bind variables cause misleading execution plans using dbms_xplan.display and dbms_xplan.display_cursor. To get the most from this tutorial, you should have some understanding of hard parse, soft parse, cardinality, histograms.

  • 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/2

      • Lecture1.1
        Agenda
        0m
      • Lecture1.2
        Lesson 1: Oracle SQL Tuning with Explain Plan
        Preview
        8m
    John Watson
    https://skillbuilders.com/our_team/john-watson/

    Please take this tutorial in order to review.

    Very useful material.
     5/5
    Mihai Barbulescu
    April 8, 2020
    • Description
    • Curriculum
    • Topic Summary
    • Instructors
    • Reviews
    Free

    You May Like

    Common Oracle SQL Tuning Errors Read More
    John Watson

    Common Oracle SQL Tuning Errors

    Free
    How to Configure an Alternate Boot Device for Solaris 11 Kernel Zones Read More
    Customer Customer

    How to Configure an Alternate Boot Device for Solaris 11 Kernel Zones

    Free
    How to Reconfigure Solaris 11 Kernel Zone Resources Read More
    Customer Customer

    How to Reconfigure Solaris 11 Kernel Zone Resources

    Free

    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.