Tanel Poder - Seminar description

Event Kontaktpersoner

Anette Nørgaard
Director of Business Development
E-mail init: ANO (efterfulgt af domænenavn: miracleas.dk)
Tlf.: +45 25 277 111

Steen Knudsen
Director Sales
E-mail init.: SSK (Efterfulgt af domænenavn: miracleas.dk)
Tlf.: +45 40 607 899

Mogens Nørgaard
Managing Director
E-mail init.: MNO (Efterfulgt af domænenavn: miracleas.dk)
Tlf.: +45 25 277 100

Henrik Bjerknæs Rasmussen
Service Manager
E-mail init.: HRA (Efterfulgt af domænenavn: miracleas.dk)
Tlf.: +45 25 277 110

Miracle Tech Feed

M.I.T. - Training & Events

Miracle Channel

Miracles online TV-station

Miracle @ Facebook

Advanced Troubleshooting for Oracle DBAs and Performance Engineers!

Seminar Description

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 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.

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

Non-objectives:
This seminar is not a beginner database tuning course
This seminar is not an SQL tuning or CBO course
Prerequisites: Good understanding of general Oracle database architecture, OS commands
Duration: 2 days (4 x 1.5h sessions per day)
Keywords: Oracle troubleshooting, performance tuning, internals

Target Audience: Database Administrators, Performance Engineers

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.

To participate in this event, please contact: Anette Nørgaard: E-mail init. ANO (Followed by @miracleas.dk)