— a summary of blocks allocated to individual schemas
prompt blocks used(well, allocated) per user
spool blocks_by_usr.lst
col sumblocks form 999,999,999
select owner, sum(blocks) sumblocks from dba_segments where segment_type like ‘TAB%’ and owner like upper(‘&owner’)||’%’ group by owner order by sum(blocks)
/
spool off
clear colu