Unit of Work Time Based Analysis (IOUG 2012 Presentation)
This presentation was given by Craig Shallahamer at both the 2011 and 2012 IOUG/Collaborate conferences. This is one of Craig's most profound and popular presentations, so you may notice it is posted for a number of difference conferences. Usually you want to download the recent version.
The download zip file contains the the presentation, the final exercise Statspack report, and the final exercise Excel spreadsheet.
To download the zip file, add this
to your chart and checkout.
Most Oracle performance analysis is now time-based with the focus on "total time": Time to process a SQL statement, a batch process, or the CPU consumed plus Oracle wait time that occurred over an interval. With just a couple twists, we can unit Operations Research queuing theory with Oracle time-based analysis, opening up an entirely new arena for performance analysis. Starting with an AWR/Statspack report, this presentation will teach you how to a perform a Unit of Work Time Based Analysis, show examples of how Oracle systems behave surprisingly as operations research indicates, and introduce how to inject your performance solutions into the analysis.
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 »