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)
The ID of the container to which the data pertains. Possible values include:
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data