Hotsos Symposium Speaker – Tanel Põder

Tanel Põder is a returning Hotsos Symposium presenter.

Biography

Tanel PõderTanel Põder is an experienced consultant with deep expertise in Oracle database internals, advanced performance tuning and end-to-end troubleshooting. He specializes in solving complex problems spanning multiple infrastructure layers such as UNIX, Oracle, application servers and storage.

He is one of the first Oracle Certified Masters in the world, passing the OCM DBA exam in 2002; he is also a proud member of the OakTable Network.

In addition to speaking at major Oracle conferences worldwide, Mr. Põder publishes his work at his Oracle internals blog: http://blog.tanelpoder.com.

Tanel is an Oracle Ace Director.

Presentation Title

Session 1: Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely
and
Session 2: Understanding LGWR, log file sync Waits and Commit Performance

Abstract

Session 1: Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely — Choosing the right entry point to performance tuning and troubleshooting is the most important prerequisite for getting reliable and consistent results. It is the first decision in problem solving process, which will direct you in the right (or wrong) direction. In this session we will cover how to define and "normalize" the problem statement, quantify the problem and where to go on from there.

This is not a deep internals session. Tanel will instead speak about his 14-year journey from a "desperate switch flipping" DBA to a systematic problem troubleshooter, plus the most important lessons he has learnt during this time.

Session 2: Understanding LGWR, log file sync Waits and Commit Performance — The commit's log file sync wait event is often misunderstood to be entirely an IO related wait. In reality there are more factors which affect your commit performance, such as the process scheduling latency and application commit rate.

This session walks you through some redo generation and writing internals, how commits happen and how the LGWR process fits into all this. After this session, you will be able to easily determine whether your log writing wait events have anything to do with bad IO performance, CPU starvation or just bad application coding practices.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

Tanel Põder

The speaker schedule is as follows: