Oracle Database 11g New Features Adaptive Cursor Sharing

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 sharing is. A demonstration is included.

This free training is segmented in several separate lessons:

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

Date: Feb 8, 2012

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