SQL Elapsed Time Analysis - OTN Tour

  • Posted on: 10 November 2011
  • By: milina.ristic
Author/Owner: 
Craig Shallahamer
This presentation focuses on how to take standard SQL statement information (e.g., from a Statspack or AWR report) and extend it in a number of practical and profound ways. We begin by investigating what the average elapsed time conveys and how most people's perception of the average doesn't match real production system experimental evidence. To better communicate and set expectations, we present other more useful statistics and visual communication techniques. Finally, we analyze what determines SQL elapsed times and how we can anticipate the impact of our performance tuning strategies.
Version: 
1
Publish Date: 
10 Nov 2011
Website: 
SQL Elapsed Time Analysis
Organization: 
OraPub Inc
Presenter Biography: 
Craig is a researcher, writer, and teacher for 1000s of Oracle professionals. His focus is Oracle performance management, which has led to a string of publishing over 24 technical papers and authoring the books Oracle Performance Firefighting and Forecasting Oracle Performance. Craig is the creator and teacher of the popular Advanced Oracle Performance Analysis, Oracle Performance Firefighting, and the Oracle Forecasting & Predictive Analysis courses. After nine years with Oracle Corporation in which he co-founded the Core Technologies and the System Performance Groups, in 1998 he left Oracle to start OraPub, Inc. He is a passionate educator, a pinnacle of Oracle knowledge, and an engaging instructor. His entertaining presentation style combines with his depth of Oracle experiences to make each presentation unique. An Oracle ACE Director, he has taught 1000s of Oracle professionals on 6 continents in 24 countries.
field_vote: