JaffySep 3 2008 — edited Sep 3 2008
I have been experiencing some indexes being unusable due to which queries and jobs taking much longer to finish. As it is very big indices its a big overhead to rebuild those indices on time, so please can anyone help here what may be cause of indices being unusable how to resolve it and factors should we look into to avoid the problem in near future.
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 on Solaris.
Thanks and Regards