Identifying performance issues beyond Oracle wait interface

Oracle provides a lot of wait events, performance statistics and metrics by default, but from time to time these metrics are still not enough to drill down the root cause of a (performance) issue. This session provides you with insights about specific OS kernel/debug features (primarily *NIX) and Oracle debug tools in general for revealing the Oracle kernel code flow in the safest way and how to interpret the outcome at its best. It includes several demos and a real life case about troubleshooting a performance issue with the mentioned methodology. All the used tools are free to use and not limited to a specific Oracle RDBMS edition.

Wednesday, 2015-11-18
09:00 am - 09:45 am
Konferenzraum EG
Oracle Database

Stefan Koehler

Freelance Consultant (Soocs)
Oracle ACEOracle OAK-Table
Stefan Koehler follows his passion about Oracle since +15 years and specialized in Oracle performance tuning, especially in Oracle cost based optimizer (CBO) and database internal related topics. Nowadays he primarily works as an independent Oracle database performance consultant and researcher in large mission critical environments (e.g. +10 TB databases) for market-leading companies or multi-billion dollar enterprises in various industries all over the world. He usually supports his clients in understanding and solving complex Oracle performance issues and troubleshooting nontrivial database issues on short-term contracting basis. He is also a proud member of the OakTable Network and is recognized/rewarded as an Oracle ACE by Oracle’s ACE program.

These lectures could also interest you