select tablespace_name,sum(ceil(bytes/1024/1024)) free_mb from dba_free_space group by tablespace_name;
select FILE_ID,BLOCK_ID,BLOCKS from dba_free_space where tablespace_name='USERS';
select tablespace_name,sum(ceil(bytes/1024/1024)) free_mb from dba_free_space group by tablespace_name;
select FILE_ID,BLOCK_ID,BLOCKS from dba_free_space where tablespace_name='USERS';