Vistas importantes en oracle

select a.tablespace_name, b.status
from dba_data_files a, v$backup where a.file_id=b.file#
order by tablespace_name;