SQL Elapsed Time Analysis (IOUG 2012 Presentation)
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
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
To receive OraPub's Newsletter »