Oracle: V$IOSTAT_FILE

select
   fil.name                    datafile_name,
   isf.filetype_name,
   isf.access_method,
   isf.asynch_io,
   isf.large_read_megabytes,
   isf.large_read_reqs,
   isf.large_read_servicetime,
   isf.large_write_megabytes,
   isf.large_write_reqs,
   isf.large_write_servicetime,
   isf.retries_on_error,
   isf.small_read_megabytes,
   isf.small_read_reqs,
   isf.small_read_servicetime,
   isf.small_sync_read_latency,
   isf.small_sync_read_reqs,
   isf.small_write_megabytes,
   isf.small_write_reqs,
   isf.small_write_servicetime,
-- isf.filetype_id,
   isf.file_no,
   isf.con_id
from
   v$iostat_file isf                                left join
   v$datafile    fil on isf.file_no = fil.file#
order by
   fil.name      nulls last
;

select
--count(*),
  filetype_id,
  filetype_name
from
  v$iostat_file
group by
  filetype_id,
  filetype_name
order by
  lower(filetype_name);
--  4   Archive Log
-- 11   Archive Log Backup
--  1   Control File
--  2   Data File
--  9   Data File Backup
-- 12   Data File Copy
-- 10   Data File Incremental Backup
-- 18   Data Pump Dump File
-- 17   Flashback Log
--  3   Log File
--  0   Other
--  6   Temp File