Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Jonathan Lewis - Trouble-Shooting & Tuning Webinar

Speak-Tech Webinars

Wednesday, April 16, 2014 from 11:00 AM to 2:30 PM (EDT)

Jonathan Lewis - Trouble-Shooting & Tuning Webinar

Ticket Information

Ticket Type Sales End Price Fee Quantity
Webinar & Recording Only (April 16 & 18) Ended $300.00 $0.00
Webinar + All 3 recordings - 6 days of Jonathan & save $100 Ended $700.00 $0.00
Webinar + Oracle Structures 2 day Recording Ended $500.00 $0.00
Webinar + Oracle Mechanisms 2 day Recording Ended $500.00 $0.00
Webinar + Indexing Strategies 1 day Recording Ended $350.00 $0.00

Share Jonathan Lewis - Trouble-Shooting & Tuning Webinar

Event Details

 Trouble-Shooting or Tuning  *** Two Days *** Wednesday, April 16 and Friday, April 18 from 10:00 to 13:30 CDT, 11:00 to 14:30 EDT

What's the difference? What are the strategies? Why tuning is hard, trouble-shooting is easy and design is important. Key targets for producing a well-tuned system on day one. How to approach design, and plan for trouble-shooting.

Finding the Problems

There are three major classes of problem, but just one source of (Oracle) information. It's important to recognize what class of problem you're attacking and pick the best way of using the available information to identify the source of your problem. We outline examples of the three classes and the corresponding approaches, and end with a detailed example of problem-solving.

Tactical/Quick Fixes

Methods, workarounds, dirty tricks and parameters for dealing with classic performance problems when the system is in production. There really aren't many quick fixes that can be applied across the board - each one needs careful examination of costs, risk, and benefits. In this session we consider some of the options that are most likely to be worthwhile.

V$, X$ and AWR Reports

It's a good idea to be familiar with just a few of the dynamic performance views - and there are a couple of items in the still hidden away in the X$ objects that can add a little value. This session will present some ideas on how to take advantage of the dynamic performance objects directly, and then move on to some of the more useful information they supply - particularly through the statspack and AWR interface - closing with a case study of using AWR to solve a performance problem.

What will you learn?

  • The different methods of generating execution paths, from autotrace to explain to v$sql_plan_statistics_all in great detail and how to choose the right method.
  • How to read execution plans -no matter how complex - in a fashion that can be described in just two steps.
  • The various omissions and errors that lead to the wrong conclusion when trying to understand how a query might run.
  • Extending understanding to features such as distributed joins, parallel execution, and partitioned tables

Note: this tutorial has recently been heavily revised to include more information about the different approaches needed for dealing with different types of situation; plus an increased volume of information about understanding and interpreting the content of AWR reports.

This webinar will be recorded and you will have free, unlimited access to the recording for 30 days afterwards.

Please feel free to contact me directly at with any questions or concerns or for more information about discounts available when sending multiple attendees.

Have questions about Jonathan Lewis - Trouble-Shooting & Tuning Webinar? Contact Speak-Tech Webinars


Wednesday, April 16, 2014 from 11:00 AM to 2:30 PM (EDT)

  Add to my calendar


Speak-Tech Webinars

Speak-Tech is Minnesota-based and has organized webinars and seminars featuring the world’s leading Oracle experts for over 12 years.

Speak-Tech has organized over 100 training events for experts such as Jonathan Lewis, Tom Kyte, Cary Millsap, Tim Gorman, Gaja Krishna Vaidyanatha and David Kurtz, considered to be some of the world’s leading experts in Oracle Performance Tuning; Syed Jaffar Hussain, Oracle ACE Director who was awarded the Oracle Excellence Award for Technologist of the Year: DBA, 2011; Steven Feuerstein, considered to the world's leading expert in PL/SQL, Jim Czuprysnski and Matt Hart, all leading experts in their Oracle specialties.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.