I am presenting on measuring performance by percentiles at RMOUG 2014 in Denver.
My session is on Friday Feb 7 at 2:45 pm at room 501.
Latest PPT: SQL Execution Outliers – final
The toolbox that used: tracking_sql_performance.zip
See you in Denver.
In the previous article, I introduced the concept of percentiles and you can hopefully see that measuring percentiles is important to track SQL performance as it makes performance metrics a lot more precise and meaningful.
Unfortunately, ORACLE does not collect percentile data out of the box, so we need to figure out a way to do it ourselves.