asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time | Tanel Poder Consulting

[utterances-bot]

asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time | Tanel Poder Consulting

I don’t have much time for a thorough blog post, so I’ll just paste in an example output of my asqlmon.sql script, which uses ASH sql_plan_line columns for displaying where inside your execution plan response time has been spent. Why not just use Oracle’s own SQL Monitoring reports? Well, SQL monitoring is meant for “long running” queries, which are not executed very frequently. In other words, you can’t use SQL Monitoring for drilling down into your frequently executed OLTP-style SQL. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

https://tanelpoder.com/2013/03/17/asqlmon-sql-sql-monitoring-like-execution-plan-line-level-drilldown-into-sql-response-time/

[lcdsantos1310]

Hello! Is there any chance for an update for RAC enabled gasqlmon.sql version?

Thanks a lot from a long-time fan!

[tanelpoder]

I haven't updated the gasqlmon.sql for a while, I think. I probably should conver the asqlmon.sql to use the GV$ views, although there's some complexity regarding linking up different child cursor#'s across RAC nodes. For now I've just used the dasqlmon.sql (might have to wait until enough v$ash data is written there).