I'm unable to find the exact bug (work with Oracle Support if you really want it) but my suggestion would be this: Upgrade to 11.1.0.7 and then apply patch 8318020 for dbms_stats. There is a significant number of fixes in 11.1.0.7 and it has been a pretty stable release IMHO and it fixes quite a number of bugs found in 11.1.0.6. On Thu, Dec 10, 2009 at 10:17 AM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote: > What you are observing is a bug in 11.1.0.6 - it does not reproduce in > 11.1.0.7. Let me see if I can find the bug. -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l