SkillBuilders Welcome  |  Log in
All Oracle Tutorials

Oracle Database 11g New Features Adaptive Cursor Sharing

Oracle Consultants Available

Will we ever get the question of the use of bind variables over literals in our SQL answered?  Mix together the following in your Oracle database environment: large tables, skewed data, histograms (or lack of), bind variables, literals, the CURSOR_SHARING initialization parameter and bind variable peeking.  The mix can lead to uneven and poor performance. 

Oracle Database 11g provides an advanced solution, another answer to the question: Adaptive Cursor Sharing.  Via feedback from the runtime engine, 11g can deliver multiple solutions (execution plans) for the same query, without code changes.

In this tutorial you will receive a brief review of the terms previously mentioned and learn what feedback-based optimization and adaptive cursor shariing is. A demonstration is included.

Dec 12 - SkillBuilders Oracle 11g PL/SQL Programming Workshop

This free training is segmented in several separate lessons:

1. Introduction to Oracle Adaptive Cursor Sharing   (2:13)   (click to read the Transcript)
2. Review SQL Statement Processing   (2:14)  
3. Common Optimization Problems and 9i / 10g Solutions   (10:00)  
4. 11g Feedback Based Optimization   (2:19)  
5. Oracle 11g Adaptive Cursor Sharing Concepts   (1:58)  
6. How 11g Adaptive Cursor Sharing Works   (5:12)  
7. Demonstration of 11g Adaptive Cursor Sharing   (7:23)  
8. 9i and 10g Features with 11g ACS   (1:50)  
9. Adaptive Cursor Sharing Summary   (1:58)  

Date: Feb 8, 2012

View all videos now - Free Online Registration required

Here is a preview:

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

Want more help?  Try:

Training: Oracle SQL Tuning for Developers and DBA's

Consulting: Short or long term assignments;  let us help you with your tuning issue!

Not Convinced?  Try our Free Performance Analysis