pavan27
asked on
rebuilding index in oracle 10.2.0.3 online
Experts,
i am planning to rebuild index online. my DB version is 10.2.0.3. i need some suggestion to rebuilding index.
how to find which index need to be rebuild?
what cases we need to rebuild indexes?
how to rebuild local indexes (partitioned indexes)?
how to rebuild global indexes?
what are the precautions i need to take while rebuild index online.
is there any negative impacts if i rebuild the index online?
please any one guide me to rebuild indexes.
i am planning to rebuild index online. my DB version is 10.2.0.3. i need some suggestion to rebuilding index.
how to find which index need to be rebuild?
what cases we need to rebuild indexes?
how to rebuild local indexes (partitioned indexes)?
how to rebuild global indexes?
what are the precautions i need to take while rebuild index online.
is there any negative impacts if i rebuild the index online?
please any one guide me to rebuild indexes.
ASKER
Thanks for quick response.
how do i find which index need to be rebuild?
is there any way to find which job /procedure/process will be slow while we are rebuilding index online?
is there any way to find resource consumption like temp space, memory utilization before rebuild the index?
how do i find which index need to be rebuild?
is there any way to find which job /procedure/process will be slow while we are rebuilding index online?
is there any way to find resource consumption like temp space, memory utilization before rebuild the index?
I attached the script which determines whether an index is a good candidate for a rebuild or for a bitmap index. All indexes for a given schema or for a subset of schema's are analyzed (except indexes under SYS and SYSTEM).
rebuild-indx.sql.txt
rebuild-indx.sql.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rebuilding indexes online will slow down an access to the corresponding table so do it hen there is not much activity going on around.
To rebuild an index:
ALTER INDEX <schema_name>.<index_name>
To rebuild a partitioned index:
rebuild the individual partitions:
ALTER INDEX <index-name>
REBUILD PARTITION <partition-name>
PARALLEL(DEGREE 4, INSTANCES 3)