db_io_type_metrics

db_io_type_metrics.pl main page

The db_io_type_metrics.pl utility is used to display database physical IO type (small, large, synchronous, reads and writes) real-time metrics. It basically takes a snapshot each second (default interval) from the gv$iostat_file cumulative view and computes the delta with the previous snapshot. The utility is RAC and Multitenant aware.

This utility:

provides useful metrics.

is RAC aware.

detects if it is connected to a multitenant database and then is able to display the containers metrics.

is fully customizable: you can aggregate the results depending on your needs.

does not install anything into the database.

It displays the following metrics per IO Type (small, large, synchronous, reads and writes):