Oracle DB File Inventory

Query to gather list of all files inside an Oracle Database

set lines 2000 pages 100
col type format a11
col name format a90
select 'SPFILE' as type, value as name from v$parameter where name = 'spfile'
union
select 'CONTROLFILE' as type, name from v$controlfile
union
select 'LOGFILE' as type, member as name from v$logfile
union
select 'DATAFILE' as type, name from v$datafile
union
select 'TEMPFILE' as type, name from v$tempfile
union
select 'DIRECTORY', directory_path||','||directory_name as name from dba_directories
order by 1,2
;
select * from dba_external_tables;
select * from v$pwfile_users;
select * from v$encryption_wallet;