-- Database files information
set underline =
set lines 150;
set pages 50;
col file_name form a50;
-- Datafiles inforamtion
TTitle CENTER 'D A T A B A S E   F I L E S' skip 1 CENTER '===========================' skip 2 
set head off;
SELECT  'Instance ' || name || '.  Time: ' ||
         TO_CHAR(sysdate, 'DD-Mon-YYYY HH24:MI:SS')
	 FROM     v$database
/
set head on;
TTitle 'Datafiles information'
select file_name,tablespace_name, status, bytes from dba_data_files
order by tablespace_name
/
Ttitle 'Log files information'
-- Log files information
col member form a40;
select a.member,a.group#, a.status, b.bytes from v$logfile a, v$log b
where a.group# = b.group#
/
-- Control file information
ttitle 'Controlfile inforamtion'
col name form a40;
select name,status from v$controlfile
/
-- Dump file locations
ttitle 'Dump file locations'
col name form a40;
col value form a40;
select name,value from v$parameter where name like '%dump_dest%' or name like
'log_archive_dest'
/