查看表大小
select segment_name as tablename,bytes/1024/1024/1024 gb from dba_segments where segment_name='TEST' and owner='CESHI';
TEST为表名 ,CESHI为用户名,注意要大写
查看所有表的数据量行数
select t.table_name,t.num_rows from user_tables t ORDER BY NUM_ROWS DESC;
select segment_name, bytes from user_segments where segment_type = 'TABLE';
或者 最好用:
Select Segment_Name, Sum(bytes) / 1024 / 1024 From User_Extents u where u.segment_type='TABLE'
Group By Segment_Name