Oracle 查看表存储内存

--分配表的物理存储
1 select segment_name, bytes 
from user_segments 
where segment_type = 'TABLE';

Select Segment_Name,Sum(bytes)/1024/1024 From User_Extents Group By Segment_Name

select num_rows * avg_row_len from user_tables where table_name = 'FCT_QUERY_LOG';