John, you got the bug number handy? Since we create indexes with compute clause, I just want to be careful. I haven't seen it yet, but a bug# would be great. rjamya On 4/11/07, John Darrah <darrah.john@xxxxxxxxx> wrote:
There is a bug in 10.2.0.2 that presents as 4031 errors when rebuilding indexes with the compute statistics clause. It causes state objects to be created in the shared pool that are never destroyed.