Re: Statistics stopping after a while

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 14 Apr 2002 21:42:24 -0700
Message-ID: <a9dlng022ji@drn.newsguy.com>

In article <8j7jbug9d2golos99o73v7hvkmh265fp71_at_4ax.com>, Sybrand says...
>
>On Sun, 14 Apr 2002 23:53:25 +1000, BC
><nsouto_at_optushome.com.au.nospam> wrote:
>
>
>What happened to those grey cells, Nuno? Too much australian beer?

There is never such a thing as too much Australian beer! ;)

>Unfortunately, both variants ought to *overwrite* statistics , even
>dbms_stats does this, when you don't provide it the name of a stats
>table. The doco explicitly states the statistics are deleted.
>Also ANALYZE definitely doesn't use multiple processors, dbms_stats
>does (there is a parameter for this)
>
>Regards
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Sun Apr 14 2002 - 23:42:24 CDT