I/O Performance

Displays the I/O statistics for each file. You can use I/O statistics to compare the activity for each data file, and to determine whether activity is evenly distributed over the data files or whether activity is concentrated on one or more particular data files.

You can access this screen using the transaction DBACOCKPIT and navigating to Performance →I/O Performance.

Features

An initial screen appears listing the all database files grouped by Data or Log. Significant measures are the time per read or write, the amount of data read or written per second and the amount of data read or written per request. Double clicking on a file presents the same metrics collected over the last 48 hours.

There is a reset/since reset functionality to measure a specific period. In addition, values are available since database start. Current values can also be displayed.