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
- 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!
- 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.