ORACLE SQL View Database Files

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;