To get the TABLESPACE SIZE from the database

select tablespace_name,sum(bytes)/1024/1024
“SIZE_IN_MB” from dba_data_files group by tablespace_name;