> Presentations >

  SQL Elapsed Time Analysis (IOUG 2012 Presentation)


Product Code: 2012_IOUG_SQL_ETA

To download click here.

This presentation was given by Craig Shallahamer at the 2012 IOUG/Collaborate conference. This is one of Craig's most popular presentations, so you may notice it is posted for a number of difference conferences. However, this IOUG presentation has been significantly updated and expanded, so you'll want to download this one.

To download the zip file, add this product to your chart and checkout.


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. First we delve into the elapsed time average; what people perceive, what the evidence shows, and ways to collect more useful and valuable elapsed time information. Second, we discuss why elapsed times change is proportional to both the amount of work to be processed and how long it takes to process each piece of work. Experimental results are shown and analyzed yielding a surprisingly deep understanding of how Oracle performance solutions impact elapsed times.

Share your knowledge of this product with other customers... Be the first to write a review

Browse for more products in the same category as this item:


view my cart my account my support contact us about us        

                                Built with Volusion                                                                 To receive OraPub's Newsletter »