Re: Todays Oracle 11.2.0.2 quiz...
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 4 Aug 2011 07:48:26 -0700
Message-ID: <CAGXkmiugq56hprcYw2M7tm7MPj=Yi_+yMe6xhwzPaOdNyv58xg_at_mail.gmail.com>
Starting in 11g (11.1.0.6)
http://structureddata.org/2007/09/17/oracle-11g-enhancements-to-dbms_stats/
Date: Thu, 4 Aug 2011 07:48:26 -0700
Message-ID: <CAGXkmiugq56hprcYw2M7tm7MPj=Yi_+yMe6xhwzPaOdNyv58xg_at_mail.gmail.com>
Starting in 11g (11.1.0.6)
http://structureddata.org/2007/09/17/oracle-11g-enhancements-to-dbms_stats/
On Thu, Aug 4, 2011 at 7:17 AM, Robert Freeman <robertgfreeman_at_yahoo.com>wrote:
> The correct value is C - You should use the Oracle default value. Starting
> in 11.2.0.2 (I think) Oracle actually does a full scan of the table. It has
> removed the need for a sort as a part of the scan, therefore the process is
> much faster and you get much more accurate statistics. So, if you have the
> sample size set, you should unset it......
>
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 04 2011 - 09:48:26 CDT