Santa's little (index) helper
Santa's little (index) helper Getting a little unexpected help is always nice. This was the case for me when I was tasked with troubleshooting a slow web application that had already received user complaints. Moreover there will be a significant increase in data in the future. As I started working on this issue, I quickly discovered that a significant amount of the application's response time was spent in an Oracle Database. This was revealed when analyzing a Java Flight Recording of the app (Socket Reads ) I used dashtop by Tanel Poder to investigate which Statements where slow in the past 14 days: @D:\tpt-oracle-scripts\ash\dashtop sql_id,sql_plan_operation,sql_plan_options username='MYSCHEMA' sysdate-14 sysdate Total