Oracle index table查询大小

--查询大小

select segment_type,segment_name, sum(bytes)/1024/1024 Mbytese

from user_segments
where segment_type in ('TABLE' ,'INDEX')
group by segment_type,segment_name order by segment_name;


--备份
create table SKPW_COND_HOUR_201705 as select * from SKPW_COND_HOUR ;
insert into SKPW_COND_HOUR_201705 select * from SKPW_COND_HOUR t;
--
truncate table SKPW_COND_HOUR
--重建
alter index SKPW_COND_HOUR_NK rebuild online;
--20%
select name,
del_lf_rows,
lf_rows,
round((del_lf_rows/(lf_rows+0.0000000001))*100) frag_pct
from index_stats