|All Oracle Classes||
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 shariing is. A demonstration is included.
This free training is segmented in several separate lessons:
Date: Recorded Feb 8, 2012
View all videos now ... Free Online Registration required
Here is a preview:
To view Full Screen, Click the box in the video lower right hand corner. Right Click on the video for More Video Controls.
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