Tanel Poder
He hosts an Oracle performance tuning site at http://www.tanelpoder.com and has published useful Oracle troubleshooting tools like Sesspack and Session Snapper.
In addition to delivering training and seminars, Tanel is a frequent speaker at major conferences such as OracleWorld, UKOUG, Hotsos Symposium, IOUG-A Live and many regional ones.
Tanel is also one of the first Oracle Certified Masters in the world and an OakTable Network member.
Tanel recently delivered an Advanced Oracle Troubleshooting session at the Oracle Open World 2008. View the slides and script here.
|
Exclusive Seminar in Australia
Advanced Oracle Troubleshooting for DBAs
and Performance Engineers with Tanel Poder
16 - 17 April 2009, Sydney
20 - 21 April 2009, Melbourne
This expert-level 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 misbehaviour.
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 two days are full of intensive learning, reading dumps, stack traces, network packet captures and Oracle SGA directly. You’ll be using debuggers and custom tools provided to you for real-time and post-mortem diagnosis.
The emphasis is put on practical troubleshooting, the safety comes first and many techniques are designed to require no change to database schemas or instance parameters.
As the seminar goes deep into Oracle internals, the attendees should already have good understanding of Oracle concepts and DBA tools in order to get most out of the training days.
Objectives:
- Understand internals of core Oracle kernel components and their interaction with OS
- Be proficient in systematic end-to-end troubleshooting, using the right tool for right problem
- Have the ability to proactively eliminate potential database performance issues
Topics:
- Systematic approach to troubleshooting and tuning
- End to end lifecycle of a database request
- Oracle, OS and hardware interaction
- Oracle kernel core services
- Oracle Wait Interface and kernel instrumentation framework
- Lifecycle of a cursor
- SQL execution row source operators and data flow
- Logical and physical IO internals
- Lifecycle of a transaction
Agenda - Day 1:
Session 1 - End to end lifecycle of a database request
This session gives an overview of the core hardware layers and software code paths a database request has to pass through. For every relevant layer a commonly available diagnosis technique or tracing tool is proposed.
Session 2 - Oracle, OS and hardware interaction
This session concentrates on what happens at OS and hardware level when Oracle needs to use operating system services or OS needs to interact with Oracle. Both Unix derivatives and Windows server family internals are discussed.
Session 3 - Oracle kernel core services
This session covers in detail the kernel services and components most of database calls interact with - and often get in trouble with.
Session 4 - Oracle Wait Interface and kernel instrumentation framework
This session concentrates on Oracle wait interface internals, shortcomings and workarounds. Also the 10g+ new end-to-end instrumentation framework is covered.
Agenda - Day 2:
Session 5 - Lifecycle of a cursor
Most of the application code execution in Oracle is done via cursors - this includes calling PL/SQL stored procedures. Different workloads require different cursor management strategies, getting it wrong may cause your system not scale regardless the amount of hardware thrown in. Getting it right requires understanding the library cache data structures and concurrency mechanisms, which this session will deliver.
Session 6 - SQL execution row source operators and data flow
This session gives you detailed understanding of what a server process has to go through when looking up records and generating result sets based on our SQL. This will be crucial for reading and really understanding SQL execution plans. You will also be introduced to a way for diagnosing where a statement has got stuck if the conventional diagnostics methods like tracing and V$/X$ queries fail to reveal it.
Session 7 - Logical and physical IO internals
This session gives you understanding of Oracle’s internal buffer cache management and key differences between many OS level IO configuration options. Also the different costs of different LIO operations are discussed along with tuning advice.
Session 8 - Lifecycle of a transaction
In addition to covering Oracle transaction management core internals, this session wraps up the topics learnt, by studying a case of a transaction life cycle, from its initialization to post-commit cleanout.
| Date: |
16 - 17 April, Sydney
20 - 21 April, Melbourne |
| Price: |
A $2250 |
|
