Monitoring I/O Resource Management (IORM) Using Database Statistics

6.3.8.2 Monitoring I/O Resource Management (IORM) Using Database Statistics

The following table describes database statistics that are useful for monitoring I/O Resource Management (IORM). The statistics are available in various dynamic performance views, including V$SYSSTAT, and may be displayed in the Global Activity Statistics or Instance Activity Statistics section of an AWR report.

Statistic	Description
`Session total flash IO requests`	Total number of physical I/O requests on flash.
`Session IORM flash wait time`	Total amount of IORM wait time for flash I/O requests (in microseconds). To determine the average IORM wait time for flash I/O requests, divide `Session IORM flash wait time` by `Session total flash IO requests`.
`PDB total disk IO requests`	Total number of physical I/O requests on disk.
`PDB IORM disk wait time`	Total amount of IORM wait time for disk I/O requests (in microseconds). To determine the average IORM wait time for disk I/O requests, divide `PDB IORM disk wait time` by `PDB total disk IO requests`.

The availability of a specific statistic is subject to the version of Oracle Database being used.

Parent topic: Monitoring I/O Resource Management (IORM)