Oracle 查看表存储内存

 

--分配表的物理存储
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';

 

 

 

posted @ 2016-04-27 00:43  fkissx  阅读(363)  评论(0)    收藏  举报