Oracle索引状态查询&索引重建
标签：color art 索引 union acl oracle索引 exe lte mil
Oracle索引状态查询&索引重建
SELECT status, COUNT(*)
FROM dba_indexes
GROUP BY status
UNION
SELECT status, COUNT(*)
FROM dba_ind_partitions
GROUP BY status
UNION
SELECT status, COUNT(*)
FROM dba_ind_subpartitions
GROUP BY status
--重建索引
alter index pk_kc03 rebuild nologging;
or
alter index pk_kc03 rebuild