SkillBuilders Welcome  |  Log in
All Oracle Tutorials

SQL Tuning with Adaptive Cursor Sharing and Cardinality Feedback

Oracle Consultants Available

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)

Jan 9 - Oracle 12c SQL Tuning for Developers and DBAs

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)  
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

View all videos now - Free Online Registration required

Here is a preview:

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