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;

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.