/* ********************************************************** */
/* c:\oracle\sql\diskio_1.sql ............. active data files */
/* Owner: R.Kupcunas                                          */
/* Date: 01-May-95                                            */
/* ********************************************************** */

spool diskio_1.rslt

col name format a40

set pages 0
set feedback off
set verify off
set lines 130
set heading off
set echo off
set pause off
set newpage 0

select substr(TS.name,1,10)		"TSP",
       substr(DF.name,1,40)           "FILE NAME",
       phyrds           "READS",
       phywrts          "WRITES"
from v$datafile DF,
     v$filestat FS,
     v$tablespace TS
where DF.file# = FS.file# 
and DF.TS# = TS.TS#
order by 1,2;

spool off;
