Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question about statistics
"DA Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1100394206.441584_at_yasure...
> wagen wrote:
>
>> We gather statistics for the database objects (user created) using
>> DBMS_STATS (9i +), ANALYZE (8i +).
>>
>> Do ANY of the initialization parameters influence the way the
>> statistics are gathered? If YES, what are the init.ora parameters?
>>
>> NOTE: I am not referring to ESTIMATE/COMPUTE/SAMPLE...
>>
>> Thanks for any pointers.
>>
>> Wagen
>
> I believe the answer is ... gathered no ... utilized by the
> optimizer yes.
I expect that setting the PARALLEL_XXX parameters to enable query parallelism at different degrees and then setting the degree parameters to DBMS_STATS differently would result in a difference in statitics gathering. I haven't tested this though.
DBMS_STATS works pretty well in 8i as well BTW.
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.comReceived on Sun Nov 14 2004 - 08:10:21 CST