Welcome to db_io_function_metrics, an utility used to display database physical IO per database functions (DBWR, LGWR, Direct Reads, Smart Scan and so on) real-time metrics. It basically takes a snapshot each second (default interval) from the gv$iostat_function cumulative view and computes the delta with the previous snapshot. The utility is RAC aware (No need to be multitenant aware as con_id=0 into gv$iostat_function for 12.1 in any cases even if pdbs are created).

This utility:

provides useful metrics.

is RAC aware.

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, reads and writes) and database functions: