強哥的部落格

select owner, table_name, tablespace_name, num_rows, blocks, blocks*8096 as blockusebyte, avg_row_len, avg_row_len*num_rows as rowusebyte

from all_tables

where owner <> 'SYS' and owner <> 'SYSTEM' and blocks is not null and tablespace_name = 'SYSTEM'

order by num_rows desc;