DBF files in ASM all PDBs included.
SET LINESIZE 250
SET PAGESIZE 100
SET FEEDBACK OFF
SET HEADING ON
COLUMN pdb_name FORMAT A20
COLUMN tablespace_name FORMAT A20
COLUMN file_name FORMAT A80
COLUMN diskgroup FORMAT A12
COLUMN size_mb FORMAT 999999
SELECT
RPAD(p.name,20) AS pdb_name,
RPAD(df.tablespace_name,20) AS tablespace_name,
df.file_name,
ROUND(df.bytes/1024/1024) AS size_mb,
SUBSTR(df.file_name,1,INSTR(df.file_name,'/')-1) AS diskgroup
FROM cdb_data_files df
JOIN v$containers p
ON df.con_id = p.con_id
ORDER BY p.name, df.tablespace_name;