doc

    Name:   allfiles.sql

    Author: Mark Gurry


The following script provides a list of the locations of all of the
datafiles, redo log files and archive logs. The aim is to spread disk 
I/O load.

#


ttitle ' Breakup of files across Disks / Check Recovery '     
select value      
	from v$parameter
 where name like 'log_archive_dest' 
UNION
select name 
	from v$datafile
UNION
select substr(member,1,55)
  from v$logfile;