-- name       : disk.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Display details of access to each disk file used in the 
--              database for both reads and writes.
-- limitation : Need access to v$datafile and v$filestat
--
-- useage     : SQL> @disk


set feed off
set linesize 250
set pages 50

spool disk.lis

col filename head "Filename" for a45
col reads head "Reads" for 999990
col writes head "Writes" for 999990
col totals head "Total" for 9999990

select 	name filename,
	phyrds reads,
	phywrts writes,
	phyrds+phywrts totals	
from 	v$datafile d,
	v$filestat f
where 	d.file#=f.file#
/

set lines 79
set pages 24
set feed on

spool off