Re: An ancient mystery

Was there a data load occurring that would have invalidated the index?

-- 
Daniel Fink

OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training

OptimalDBA    http://www.optimaldba.com
Oracle Blog   http://optimaldba.blogspot.com

Lost Data?    http://www.ora600.be/


Dennis Williams wrote:


> List,

>  

> The situation:

>  

> Oracle 8.1.7.4 <http://8.1.7.4> database on Solaris 8 (soon to be 

> upgraded to 10g)

> Rule-based Optimizer

>  

> A query which has run for years using an indexed access to a very 

> large table (maybe 100 million rows)

> suddenly decides to use a full-table scan, shutting down a critical 

> business process.

>  

> Then after several hours, it switches back to using the index.

> All concerned claim that nothing changed before or after.

>  

> Needless to say the business users are nervous. They think maybe the 

> database grew beyond some limit.

>  

> Can anyone think of an explanation?

>  

> Thanks,

> Dennis Williams




--
http://www.freelists.org/webpage/oracle-l