USE DYNAMIC PERFORMANCE VIEWS TO DETERMINE WHAT DATAFILES AND TABLESPACES MAKE UP THE DATABASE AS WELL AS THE SIZE OF THE DATAFILES

OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P18 POTX

2. Use dynamic performance views to determine what datafiles and tablespaces make up the database as well as the size of the datafiles:

select t.name,d.name,d.bytes from v$tablespace t join

v$datafile d on t.ts#=d.ts# order by t.name;