Doc

    Name:    datafile.sql

    Author:  Mark Gurry


    this script checks the locations of all datafiles for the selected database
    Remember to balance your disk I/O load across disks 

#

column value  format a40
column name   format a40
column member format a40


spool datafile.lis  

ttitle ' Checking Locations of Database Files' 

select value
  from v$parameter
 where name = 'log_archive_dest'
UNION
select name 
  from v$datafile 
UNION
select member      
  from v$logfile 
/
spool off