Re: Statistics stopping after a while

On Sun, 14 Apr 2002 23:53:25 +1000, BC
<nsouto_at_optushome.com.au.nospam> wrote:

>In article <ndgebu46ckafsq1ahubhanpuliq5i085r9_at_4ax.com>, you said (and I
>quote):
>>
>> But I was really surprised when I saw that statistics was gathered
>> only on one part (around 1/3 eg 100 tables) of tables of my main
>> schema.
>
>IIRC, one (or both) of the PL/SQL standard distribution analyze packages
>does "optimize" itself by looking for existing stats in the objects. If
>it finds them, then it bypasses the analyze.
>You have to run it twice: once to DELETE any existing stats, then again
>to let it gather the stats. Which it will do using parallel processing.

What happened to those grey cells, Nuno? 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 Received on Sun Apr 14 2002 - 10:23:42 CDT