查询表或者索引的实际大小:
比如表有多少个数据块,有多少条记录
select blocks from dba_segments where owner='TEST' and segment_name ='表名字';
select blocks from dba_segments where owner='TEST' and segment_name='索引名字';
转载于:https://blog.51cto.com/yeluyide/1135387
查询表或者索引的实际大小:
比如表有多少个数据块,有多少条记录
select blocks from dba_segments where owner='TEST' and segment_name ='表名字';
select blocks from dba_segments where owner='TEST' and segment_name='索引名字';
转载于:https://blog.51cto.com/yeluyide/1135387