oracle 查看表占用空间大小

分配给表的物理空间大小 GB
select (sum(bytes) / 1024 / 1024 / 1024) as MEMORYSIZE
from user_segments
where segment_name = ‘TABLE_NAME’

表实际占用的空间大小，根据行数*平均行长度，先执行分析语句
analyze table BUSSINESS_LOG compute statistics;
select num_rows, avg_row_len, num_rows * avg_row_len
from user_tables
where table_name = ‘TABLE_NAME’;