[管理脚本] 用户占用空间

select
    owner,
    sum(bytes)/1024/1024 as "SIZE(M)",
    sum(blocks) as "TOTAL_BLOCKS",
    sum(extents) as "TOTAL_EXTENTS"
from
    dba_segments
group by owner
having owner=upper('&user')
/