SQL> set linesize 200
SQL> select segment_name, sum(bytes / 1024 / 1024/1024)
from dba_segments
where segment_name='T_PM_DEBIT_CARD'
group by segment_name; 2 3 4
SEGMENT_NAME SUM(BYTES/1024/1024/1024)
--------------------------------------------------------------------------------- -------------------------