Tbs_usage_metrics_check

select TABLESPACE_NAME,USED_SPACE/1024/1024/1024 USED_SPACE_GB,TABLESPACE_SIZE/1024/1024/1024 TABLESPACE_SIZE_GB,USED_PERCENT from dba_tablespace_usage_metrics
where TABLESPACE_NAME='&TBS_NAME';