V$IOSTAT_CONSUMER_GROUP displays disk I/O statistics for consumer groups. If the resource manager is enabled, then I/O statistics for all consumer groups that are part of the currently enabled resource plan are captured.
Consumer Group ID
Number of single block megabytes read
Number of single block megabytes written
Number of multiblock megabytes read
Number of multiblock megabytes written
Number of single block read requests
Number of single block write requests
Number of multiblock read requests
Number of multiblock write requests
Number of I/O waits by consumer group
Total wait time (in milliseconds)
Scripting on this page enhances content navigation, but does not change the content in any way.