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
advanced
English
Oracle Database
Demo
Koehler

Stefan Koehler

Freelance Consultant (Soocs)
Oracle OAK-Table
Stefan Koehler follows his passion about Oracle since +13 years and specialized in Oracle performance tuning, especially in Oracle cost based optimizer (CBO) and database internal related topics. Nowadays he primarily works as a freelance Oracle database performance consultant 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.

These lectures could also interest you