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.
--
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
Received on Sun Apr 14 2002 - 08:53:25 CDT
