11啊

select index_name,degree,num_rows,distinct_keys from user_indexes where  lower(table_name)='t_bme_subscriberrela'

select a.num_rows,a.chain_cnt,a.blocks, round(a.num_rows*a.avg_row_len*1.1/1024/8-a.blocks) sp  from user_tables a where  lower(table_name)='t_bme_subscriberrela'

 

SELECT segment_name, bytes / 1024 / 8 jk
  FROM user_segments
 WHERE lower(segment_name) = 't_bme_subscriberrela'
    OR segment_name IN
       (SELECT index_name
          FROM user_indexes
         WHERE lower(table_name) = 't_bme_subscriberrela')

 

 EXEC  dbms_stats.gather_table_stats(ownname       => null,
                                      tabname          => 't_bme_subscriberrela',
                                estimate_percent => dbms_stats.AUTO_SAMPLE_SIZE);