Quote Originally Posted by ebrian View Post
Running gather_fixed_objects_stats again wouldn't necessarily hurt anything. In fact, with 10g it is recommended that you do analyze the fixed objects.
First off, thanks so much for recommending this course of action. Script now runs in 7 minutes compared to 90 mins. I am no longer getting temp tablespace issues either.

Can you explain to me what this has done to resolve the problems i was having?
Cheers
Phil