Oracle tablespace quotas

 col  username          format A12
 col  tablespace_name   format A14  heading Tablespace
 col  bytes             format 999,999,999
 col  blocks            format 999,999
 col  max_bytes         format 999,999,999
 col  max_blocks        format 999,999


compute sum of bytes  on tablespace_name
compute sum of blocks on tablespace_name
compute sum of max_bytes  on tablespace_name
compute sum of max_blocks on tablespace_name

break on tablespace_name skip 1

select tablespace_name,
     username,
     bytes,
     max_bytes,
     blocks,
     max_blocks
from sys.dba_ts_quotas
order by tablespace_name,
     username;