I’ve said in the past that one of the best new features, in my view, in 11g was the appearance of proper virtual columns; and I’ve also been very keen on the new “approximate NDV” that makes it viable to collect stats with the “auto_sample_size”.
Who’d have guessed that if you put them both together, then ran a parallel stats collection it would break :(
The bug number Karen quotes (10013177.8) doesn’t (appear to) mention extended stats – but since virtual columns, function-based indexes, and extended stats share a number of implementation details I’d guess that they might be affected as well.
Update
This bug is fixed in 11.2.0.3 and 12.1.0.1.
Oracle Scratchpad 
great insight into oracle 11g
Comment by lkafle — July 1, 2011 @ 4:49 am BST Jul 1,2011 |
Oracle supplied us a patch for this bug that we applied and tested successfully today. See http://karenmorton.blogspot.com/2011/07/bug-update.html for the link to the patch.
Comment by Karen Morton — July 13, 2011 @ 11:03 pm BST Jul 13,2011 |
Karen,
Thanks for the update.
Comment by Jonathan Lewis — July 25, 2011 @ 8:03 am BST Jul 25,2011 |