DATABASE FILE NOTES

 

Files

DATABASE FILE NOTES:

Filename - Name of the file(s)

Location - Location of the file(s)

select  'Archived Log Directory' "Filename",
 value "Location"
from  v$parameter
where  name = 'log_archive_dest'
UNION
select  'Control Files' "Filename",
 value "Location"
from  v$parameter
where   name = 'control_files'
UNION
select  'Datafile' "Filename",
 name "Location"
from    v$datafile
UNION
select  'LogFile Member' "Filename",
 member "Location"
from   v$logfile