Hello. Welcome to today's webinar. My name is Dave Anderson. I'll be presenting today. Also presenting today is Oracle Certified Master John Watson.

Welcome, John.

John: Hello. Good afternoon.

Dave: This is the third and possibly last webinar in this particular series, the SkillBuilders series on the four critical new features. We've done parallel processing enhancements, results cache and, John, we just recently did SQL plan management also known as SQL baselining, and today we will learn about adaptive cursor sharing or ACS, a technique that lets the database adapt to changing bind variable values. We might also sneak in a bit of learning on cardinality feedback, somewhat of a related feature in that it is a feedback-related feature.

Here's what we'll do today: Just a very brief review of SQL statement processing, then we'll look at what problems Oracle is trying to solve with these features - with the feature of ACS and cardinality feedback. We'll talk a little bit about what were previous solutions; John will be jumping in to help us there. We'll take a look at the notion, the concept, of feedback-based optimization, which provides or is the foundation of 11g adaptive cursor sharing.

We'll also want to see how the old features and the new features work together. There are a lot of things like baselining and SQL profiles and so forth, hints. We need to see if these things all mix, and then we'll take a look, if time permits, at 11g cardinality feedback.