by Tanel Põder
This seminar is concentrated entirely on Oracle troubleshooting – understanding what exactly is Oracle doing right now or what was it doing when the problem occurred. You will gain the skill to systematically work out the reasons for crashes, hangs, bad performance or other misbehavior.
The seminar takes a holistic approach for end-to-end troubleshooting. It will explain the full lifecycle of a database request, from database client libraries and network to Oracle database kernel and underlying OS. For each layer a troubleshooting technique is provided, along with advice on using the right tool for the right problem at the right time.
The seminar days are full of intensive learning, reading dumps, stack traces and querying advanced V$/X$ views. You’ll also be using OS-level tools and custom scripts provided to you for real-time and post-mortem diagnosis.
The emphasis is put on practical troubleshooting, the safety comes first and most techniques are designed to require no change to database schemas or instance parameters.
You will learn: