select sum(d.bytes)/1024/1024/1024||'G' as total_bytes, d.tablespace_name
from dba_data_files d
where d.tablespace_name = 'UNDOTBS03'
group by d.tablespace_name
--
select * from v$tablespace
from dba_data_files d
where d.tablespace_name = 'UNDOTBS03'
group by d.tablespace_name
--
select * from v$tablespace