SQL Tuning with Adaptive Cursor Sharing and Cardinality Feedback

Learn the 12c features related to SQL tuning! Oracle Certified Master John Watson teaches with examples and demonstrations: Adaptive Execution Plans and Cardinality Feedback (enhanced in Oracle Database 12c).

Prerequisites:  Reading an Execution Plan (a free tutorial)

SkillBuilders series of tutorials on tuning SQL in Oracle Database 12c

  1. Oracle 12c SQL Tuning – Adaptive Execution Plans   (10:11)   (click on video below)
    Learn an Oracle Database 12c new performance feature – Adaptive Execution Plans. During execution, Oracle Database can switch the SQL to a new plan. A very powerful corrective measure! But if you don’t know about it , how can you possibly tune SQL in Oracle Database 12c? Time to learn 12c!
  2. Re-Optimization of Execution Plans with Cardinality Feedback   (15:37)
    Cardinality feedback, introduced with Oracle Database 11g, has been significantly enhanced with 12c. Cardinality feedback allows the CBO to learn from a cardinality estimate mistake and re-optimize the execution plan. Learn more in this free SQL Tuning tutorial…

 

Date: Apr 15, 2014


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

 

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×