Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Post Details

Added on Oct 14 2020
0 comments
117 views