select
tablespace_name
,sum(bytes) / 1024 / 1024 / 1024 size_gb
,sum(blocks)
from
dba_free_space
where
tablespace_name = 'USERS'
group by
tablespace_name
;
select
tablespace_name
,sum(bytes) / 1024 / 1024 / 1024 size_gb
,sum(blocks)
from
dba_free_space
where
tablespace_name = 'USERS'
group by
tablespace_name
;