any risk if i rebuild my indexes?
755353Nov 17 2011 — edited Nov 20 2011Hi
We have TB size db, with huge amount of data load … (350GB data arrived between jan to November)
Awr showing huge db file sequential read and scattered read.
Many indexes were created 2 years ago and last rebult date is shown as last year....not sure of dba prior me ran any manual index rebuil operation.. ( nothing documented).
Is there any harm in rebuilding couple of those big indexes?
PS:stats are up to date for those indexes, They are analyzed as part of default auto stat gather job.
Some are 40 or 50GB in size…
any tips on how to check efficiency of those indexes and whether good candidate for rebuild?
is there overhead if i enable index monitroing ? is it worth enabling or hsould i go ahead and do one time rebuild? does monitroing tell you whether its not using the index because it needs rebuilding?
any easy way of finding out whether oracle doing many full table scan?
thank you
V11.2.0.2