Hotsos Symposium Speaker – Maria Colgan

Maria Colgan is a returning Hotsos Symposium presenter.


Maria ColganMaria 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 Data Warehouse Best Practices and the Oracle optimizer. 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 Data Warehouse best practices and dealing with the Optimizer.

Presentation Title

What to Expect from the Latest Version of the Oracle Optimizer


The Oracle Optimizer is one of the most fascinating aspects of the Oracle Database. With each new release the Optimizer evolves as we strive for the holy grail of always finding 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, with easily reproduced examples, how the latest version of the Optimizer works and the best ways you can influence its decisions to ensure you get an optimal execution every time.

Presentation Materials

Presentation materials are available online to attendees only.


The speaker schedule is as follows: