Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
sqlmonitor showing logical IO's at line level.

Rajeshwaran, Jeyabal
Member Posts: 87 Bronze Badge
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