Index

Index alteration

  To get the unusable indexes and set them fix.

select owner,index_name,status,degree from dba_indexes where index_name='I_SNAP$_RA_CUST_RELATE_SNA';

                                                 -- Degree = parallelism,Number of parallel operations on table/index.

                                                 -- Status   =  Valid,Unusable ( you did  some sort of direct path operation) 

    

alter index GENESIS.I_SNAP$_RA_CUST_RELATE_SNA rebuild online compute statistics
                                                -- Online = NO blocking
                                                --  nologging;

alter index GENESIS.I_SNAP$_RA_CUST_RELATE_SNA rebuild online parallel 10;

      +++++++++++++++++++++++++++

  select 'alter index '||owner||'.'||index_name ||' rebuild online nologging;'

  2  from dba_indexes

  3  where owner=upper('hr');

set lin 1000

set pagesize 1000

spool index_170715.sql

select 'alter index '||owner||'.'||index_name ||' rebuild ;' from dba_indexes where owner='ODB';

spool off