Forum Stats

  • 3,825,248 Users
  • 2,260,487 Discussions
  • 7,896,466 Comments

Discussions

sqlmonitor showing logical IO's at line level.

It would be good if  sql monitor reports the logical io's (buffer gets) for each step in plan like how "gather_plan_statistics" hint reports rather having "IO statistics" summary at the top right corner. That way we could easily focus on where we spend most of IO's per execution.

Currently this is not available till 19c, need all your support to have this voted and added in the future database releases.


https://asktom.oracle.com/pls/apex/asktom.search?tag=real-time-sql-monitoring-doesnt-show-my-query#9544012900346956835

Rajeshwaran, Jeyabalconnor_mc_d-Oracleberx
3 votes

Active · Last Updated