Re: dbms_stats.gather_table_stats only calculating stats for first partition of range interval - list composite partitioned table

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: pjhoraclel@xxxxxxxxx
  • Date: Thu, 10 Dec 2009 10:57:31 -0800

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


Other related posts: