Hotsos Symposium Speaker – Maria Colgan

Maria Colgan is a new Hotsos Symposium presenter.

Biography

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

Session 1: Implement Best Practices for Extreme Performance with Oracle Data Warehousing

Session 2: Oracle Optimizer — Top Tips to Get Optimal SQL Execution All the Time

Abstract

Session 1: Implement Best Practices for Extreme Performance with Oracle Data Warehousing — Attend this session to learn best practices for deploying a data warehouse on Oracle Database 11g. Using detailed examples, this session will cover the best practices for schema design, hardware configuration, data loading, partitioning strategies, parallel query, and workload management. You will also learn how to monitor, diagnose, and correct common performance issues using both the old reliable tools such as explain plan as well as an introduction to the latest and greatest SQL monitor tool. By applying what you learn in this session you will be able to deploy a data warehouse that can seamlessly scale without constant tuning or tweaking.

Session 2: Oracle Optimizer — Top Tips to Get Optimal SQL Execution All the Time — This session shows the process of identifying and resolving the most common SQL execution performance problems including poor cardinality estimations, selecting the wrong access method, and more. With clear how-to examples you will learn how the Optimizer determines an execution plan, from the types of statistics it looks at in each case to the formulas it uses to calculate the cardinality estimates for each operation in the plan. By understanding how the Optimizer thinks you will be able to determine if the execution plan you are looking at is the best plan you could get and, if not, why the Optimizer got it wrong. By applying some of the simple procedures explained in this session you will be able to quickly resolve these issues without the necessity of Optimizer hints or messing with initialization parameters.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: