Of course, you're absolutely right which is why I see rebuilding as a work around while I try and figure out why re-analysing doesn't solve the issue. Where I'm "lost" is what steps to take to isolate the issue. Cheers Steve Karsten Weikop wrote: >Hi Steve > >Please read the execellent paper from Richard Foote (which can be >downloaded from Miracle's site): > >http://www.miracleas.dk/images/upload/Docs/Richard%20Foote.pdf > >Conclusion form this paper: Never Rebuild, but find the course to the >problem. > >In order to help you, we need some tracefile (perhaps also a 10056 >event) in order to help you). > >/karsten > -- //www.freelists.org/webpage/oracle-l