Hotsos Symposium Speaker – Ric Van Dyke

Mr. Van Dyke is a new Hotsos Symposium presenter.

Biography

Ric Van DykeMr. Van Dyke has 20 years of experience in the IT industry. He worked as a developer and database administrator with Oracle starting with Version 6. Mr. Van Dyke worked for Oracle Corporation for 10 years primarily as a core database instructor where he taught and developed several courses. Mr. Van Dyke also served in the Advanced Technologies Services consulting group as a technical manager where he worked with several clients doing RAC installs and performance engagements. His primary role at Hotsos is as an instructor, but he also does performance consulting engagements and frequently speaks at local user group meetings.

Presentation Title

Intelligent Cursor Sharing

Abstract

In 11g, Oracle introduced a new feature called Intelligent Cursor Sharing. Bind peeking has been around for quite awhile and works well when all the values used for the binds in your statement have similar selectivity. However, if there is skew in the data such that different plans should be used depending on what the bind values are at run time, bind peeking can actually pose a problem. Oracle hopes to solve this with the introduction of Intelligent Cursor Sharing. This presentation will review what is happening with this new feature and give you some insights about how Intelligent Cursor Sharing works.

Presentation Materials

Presentation materials are available online to attendees only. Ric's presentation can be found on the Hotsos portal. Please use portal id rather than email address to log in.

Schedule

The speaker schedules can be found at the following links: