Intermediate SQL Color Coded SQL, UNIX and Database Essays

6Feb/140

RMOUG 2014 Training Days: Finding SQL execution outliers

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.

Filed under: Uncategorized No Comments
2Feb/142

How to track SQL performance. Part 3: Measuring percentiles

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.