io.sql
Download Script
set pages 100
set feedback off
alter session set nls_date_format = 'dd-Mon-yyyy hh24:mi:ss';
select sysdate from dual;
prompt
prompt Physical Reads and Writes on Files...
prompt
col name for a50
select name, phyrds, phywrts
from v$datafile df, v$filestat fs
where df.file# = fs.file#
order by 2 desc,3 desc;
prompt
prompt Physical Reads and Writes by Filesystem...
col FS heading 'File|Sys' for a6
select substr(name,1,instr(name,'/',1,2)-1) FS, sum(phyrds), sum(phywrts)
from v$datafile df, v$filestat fs
where df.file# = fs.file#
group by substr(name,1,instr(name,'/',1,2)-1)
order by 2 desc, 3 desc;
exit
