Tablespaces used by a user ?

Tablespaces used by a user ?

select    tablespace_name
,    ceil(sum(bytes) / 1024 / 1024) "MB"
from    dba_extents
where    owner like '&USERNAME_IN_CAPS'
group by tablespace_name
order by tablespace_name

*******************