按用户统计表占用情况
SELECT t.owner, trunc(SUM(db_size),3) db_size_M FROM(
select owner,table_name,
NUM_ROWS,
BLOCKS*(select to_number(p.VALUE) from v$parameter p where p.NAME = 'db_block_size')/1024/1024 db_size,
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables t
order by BLOCKS desc
)t
group by t.owner
order by db_size_M desc;
统计表占用
select owner,
table_name,
NUM_ROWS,
BLOCKS * (select to_number(p.VALUE) from v$parameter p where p.NAME = 'db_block_size') / 1024 / 1024 db_size,
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables t
order by t.owner, T.BLOCKS desc
select table_name,blocks*8192/1024/1024 size_m from user_tables where blocks is not null order by size_m desc