Listar Arquivos Tablespace
select name from v$controlfile
union all
select name from v$tempfile
union all
select name from v$dbfile
union all
select member from v$logfile
About Author
select name from v$controlfile
union all
select name from v$tempfile
union all
select name from v$dbfile
union all
select member from v$logfile