SQL Tuning with Adaptive Cursor Sharing and Cardinality Feedback | Re-Optimization of Execution Plans with Cardinality Feedback

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)
   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) (click on video below)
   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.