DBSPaces Script compatible with CDB

dbspaces.sql

select  type, sum(bytes)/1048576 mb

from    (select 'Datafile' type, bytes from cdb_data_files

        union all

        select 'Tempfile' type, bytes from cdb_temp_files

        union all

        select 'OnlineRedo' type, bytes*members bytes from v$log

        union all

        select 'Ctlfile' type, file_size_blks*block_size bytes from v$controlfile

        union all

        select 'BCTfile' type, nvl(bytes,0) bytes from v$block_change_tracking)

group by type

order by type;