--分配表的物理存储
1 select segment_name, bytes 2 from user_segments 3 where segment_type = 'TABLE'; 4 5 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';