Monitoring I/O by Function

The I/O Function charts determine I/O usage level by application or job. The component-level statistics give a detailed view of the I/O bandwidth usage, which you can then use in scheduling jobs and I/O provisioning. The component-level statistics fall in the following categories:

• Background type

  This category includes ARCH, LGWR, and DBWR.

• Activity

  This category includes XML DB, Streams AQ, Data Pump, Recovery, and RMAN.

• I/O type

  The category includes the following:

  • Direct Write

    This write is made by a foreground process and is not from the buffer cache.

  • Direct Read

    This read is physical I/O from a datafile that bypasses the buffer cache and reads the data block directly into process-private memory.

  • Buffer Cache Read

• Others

  This category includes I/Os such as control file I/Os.

To monitor I/O by function: 

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 I/O Function.

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

4. Click the largest block on the chart or its corresponding function in the legend to drill down to the function with the highest I/O rate.

   The I/O Details page appears.

   You can view real-time or historical data for details on I/O megabytes or I/O requests.