計算 Table 所佔用的磁碟空間

計算 Table 所佔用的磁碟空間

select owner,table_name,num_rows,
blocks * (select value from v$parameter where name = 'db_block_size') / 1024 / 1024 "size mb",
empty_blocks,last_analyzed
from dba_tables
where table_name='資料表'

TABLESPACE空間
select a.TABLESPACE_NAME, to_char(a.BYTES/(1024*1024),'999,999') "Size(MB)", to_char(round((a.BYTES-b.BYTES)/(1024*1024),0),'999,999') "Used(MB)", to_char(b.BYTES/(1024*1024),'999,999') "Avail(MB)" from (select TABLESPACE_NAME, sum(BYTES) "BYTES" from dba_data_files group by tablespace_name) a, (select TABLESPACE_NAME,sum(BYTES) "BYTES" from dba_free_space group by tablespace_name) b where a.TABLESPACE_NAME=b.TABLESPACE_NAME;