CODE EXAMPLE FOR SQL

Oracle list datafiles

SELECT
FILE_NAME, 
BLOCKS, 
TABLESPACE_NAME
FROM DBA_DATA_FILES;