Oracle 11g CBO New Features

Learn what's different about cost-based optimization in 11g Release 2. In this training Dave Anderson will guide you through some critical performance and SQL tuning enhancements and other surprises in the Oracle 11g cost-based optimizer. Through live demonstrations and lecture, you will learn about features such as adaptive cursor sharing, feedback-based optimization, new join techniques, DBMS_STATS enhancements, direct (PGA) reads for "large" full table scans, new hints and more.
Presented at NYOUG by SkillBuilders' Founder and Oracle DBA, Dave Anderson.

Category:

Education

Tags:

• oracle
• database
• 11g
• cbo
• tuning
• sql
• performance
• tutorial
• lesson
• video
• training
• learn
• free
• dave anderson
• feedback based
• optimization
• skillbuilders.com