Hotsos Symposium Speaker – Maria Colgan

Maria Colgan is a returning Hotsos Symposium presenter.

Biography

Maria ColganMaria Colgan is a Master 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

Tuning SQL in a Data Warehouse Environment

Abstract

Traditionally, SQL tuning techniques involve gazing at a statspack or AWR report, identifying important wait events, enqueues, latches, and parameters that need attention. In a data warehouse environment, the techniques required are drastically different. SQL statements are rarely repeatable, and the ones that are have complex execution plans involving Optimizer transformations, parallel execution and operations that can be offloaded in an Exadata environment. In this session, we will discuss a straight forward approach to tackling SQL tuning in a Data Warehouse environment and use a real-world example to demonstrate how you should navigate the complex execution plans found in the a Data Warehouse environment.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: