Presentation Title: Oracle Optimizer: An Insider’s View of How the Oracle Optimizer Works
Speaker: Ms Maria Colgan, OakTable
Company: Oracle
Presentation abstract: With each new release the Optimizer evolves as we strive to find the optimal execution plan for every SQL statement. Understanding how the Optimizer operates and what influences its choices helps you provide the necessary information to make that nirvana a reality. This session explains in detail, how the latest version of the Optimizer works and the best ways you can influence its decisions.
Presentation begins: 05/12/2012 09:55
Presentation duration: 60
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: All experience levels
Audience function: Oracle, Partner, Product Expert, Product User
Speaker biography: Maria Colgan is a senior principal product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibilities are the Oracle Optimizer statistics, and SQL Tuning. Based on Maria's extensive experience in Oracle's Server Technology Performance Group - where she conducted competitive customer benchmarks and tuning sessions - Maria creates and lectures on the Oracle Optimizer and the statistics that feed it. She is also a contributing author to the Oracle Optimizer blog
Related topics: Oracle RDBMS: Database Management, Oracle RDBMS: Features and Options, Oracle RDBMS: Performance Management
Hall: Hall 5