--检查对象有效性
select object_name, object_type, status from user_objects where status <> 'VALID';


--索引列查看
select  index_name, COLUMN_NAME
from user_ind_columns where table_name='SMSG_LOGS'  order by 1;
 
--检查索引在哪些列上
select index_name, column_name , table_name from user_ind_columns  order by 1;

--检查索引状态及是否分区
select index_name, status,partitioned  from user_indexes where table_name='SMSG_LOGS'

--查看索引占用多大空间（M）;
 select sum(u.BYTES)/1024/1024 from user_segments u where u.segment_name='SYS_C0026464';