/* ******************************************************* */
/* c:\oracle\sql\fileio_1.sql ........ file I/O statistics */
/* Owner: R.Kupcunas                                       */
/* Date: 01-may-95                                         */
/* ******************************************************* */

REM File : fileio.sql 
REM funciton: detailed data file I/O statistics
REM called by   : Called from bm_driver
REM

col name format a50

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 'fileio:',
      df.file#, 
      name, 
      phyrds, 
      phywrts
from v$datafile DF, v$filestat FS
where DF.file# = FS.file#
union
select 'fileio:',
      TF.file#, 
      name, 
      phyrds, 
      phywrts
from v$tempfile TF, v$tempstat TS
where TF.file# = TS.file#
order by 1,2,3;


spool fileio_1.rslt;
/
spool off;


