Buy One, Get One Free (for a limited time) - Act Today!

DOUG and Speak-Tech have decided to offer a “Buy One, Get One Free” program for a limited time.  Each person who registers for a seminar can designate another individual who can attend free of charge.   The other person(s) will not receive the free copy of Jonathan’s book. 

So, register for either or both seminars and you will receive a confirmation and a request for you to designate the person(s) who will be able to attend the seminar(s) free.

Who should attend?

Experienced DBAs and Developers.

This is a fast-paced class and attendees should have a good understanding of Oracle.

 Each registrant will receive a free copy of Jonathan's new book "Oracle Core: Essential Internals for DBAs and Developers", a $31.91 value.

Beating the Oracle Optimizer

This new class is a follow-on from the course "Designing Optimal SQL", and focuses on writing SQL to emulate transformations that are currently not available to the Oracle Optimizer. The other course was essentially a guide to writing "normal" SQL in the best possible way - this course is about writing "abnormal" SQL because that's the only efficient thing to do.

Each registrant will receive a free copy of Jonathan's new book "Oracle Core: Essential Internals for DBAs and Developers", a $31.91 value.

Trouble-Shooting & Tuning

The users are complaining right now ! How do I find the problem – what’s the short term fix – what’s the long term fix?

The overnight batch ran on until 9:30 this morning when it’s supposed to complete at 5:00 a.m. – what went wrong?

Good performance starts with good design – which means you have to know how much data you have, where to put it, and how you’re going to use it. Working out the best strategies is called tuning. After go-live you don’t do tuning, you do trouble-shooting, and  the strategies have to change to suit the circumstances.

In this one-day course, we learn how to think around design issues (the tuning) as well as looking at strategies – and some fixes – for addressing implementation problems (the trouble-shooting). The final session of the course examines some of the dynamic performance views, what you can do with them, and how their contents are reported in the Statspack and AWR reports.