Database Software

Hi all,

I have below query to get details of  data files of pdb from cdb.

SELECT p.PDB_ID, p.PDB_NAME, d.FILE_ID, d.TABLESPACE_NAME, d.FILE_NAME,d.BYTES

  FROM DBA_PDBS p, CDB_DATA_FILES d

  WHERE p.PDB_ID = d.CON_ID

  AND  d.TABLESPACE_NAME = 'DUMMY'

  ORDER BY p.PDB_ID;

Please help me to get  percentage_used sapce , space_free space_used fro PDB table space from CDB

Thanks in advance