Monitoring I/O by Consumer Group

When Oracle Database Resource Manager is enabled, the database collects I/O statistics for all consumer groups that are part of the currently enabled resource plan. The Consumer Group charts enable you to monitor I/O by consumer group.

A resource plan specifies how the resources are to be distributed among various users (resource consumer groups). Resource consumer groups enable you to organize user sessions by resource requirements. Note that the _ORACLE_BACKGROUND_GROUP_ consumer group contains I/O requests issued by background processes.

To monitor I/O requests by consumer group: 

1. From the Database Home page, click Performance.

   The Performance page appears.

2. In the instance activity chart, click I/O.

   The I/O Megabytes per Second and I/O Requests per Second charts appear.

3. For I/O Breakdown, select Consumer Group.

   The I/O Megabytes per Second by Consumer Group and I/O Requests per Second by Consumer Group charts appear.