Hotsos Symposium Speaker – Tanel Põder

Mr. Põder is a prior 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.

Presentation Title

#1: Zero Slides: The Scripts and Tools which Will Make Your Life Easier and Allow You to Troubleshoot Better

and

#2: Understanding Oracle SQL Plan Execution: How It really Works

and

#3: Latch, Lock and Mutex Contention Troubleshooting in Oracle

Abstract

  • #1 Zero Slides: The Scripts and Tools which Will Make Your Life Easier and Allow You to Troubleshoot Better: As the title already says, this presentation has no slides at all (as we do not use slides;)

    Instead the presenter will demonstrate some of the most useful tools he uses for accurate Oracle performance troubleshooting. The toolset ranges from plain SQL statements to Unix and Dtrace scripts and some custom-built GUI tools.

    During the session you will be taken through few troubleshooting case studies following a systematic troubleshooting methodology. For anyone interested in Oracle internals and performance tuning, this session should be a fun learning exercise!

  • #2 Understanding Oracle SQL Plan Execution: How It really Works: Even though SQL statements and their compiled execution plans are just declarations of what work needs to be done, when Oracle gets to execution of a SQL statement, all processing is done procedurally. Every rowsource, join method and access path is internally just a serial loop, continuing as long as there is data flowing from its child rowsources.

    This session gives you an in-depth understanding how Oracle SQL plan execution physically works, a step beyond just interpreting the logical view of execution plan trees. This should give you good foundation for troubleshooting complex SQL performance issues, understanding in which cases one join method is better than another and making more suitable physical design decisions.

  • #3 Latch, Lock and Mutex Contention Troubleshooting in Oracle: Oracle uses many different types of internal locks for concurrency control purposes. This session explains how latches, enqueue locks and the new KGX mutexes work and how to troubleshoot their contention problems. Also, we will go through a few case studies of common contention problems — including enqueue deadlock analysis.

Presentation Materials

Presentation materials are available online to attendees only. Tanel's materials may be found on the Hotsos portal. Attendees may use their portal ids to log in to retrieve the materials.

Schedule

The speaker schedules can be found at the following links: