Having problems with message search?
Hello Everyone,
We have upgraded from Oracle 9i to 10g (10.2.0.4).
We are trying to understand the behaviour of DBMS_STATS
in our new environment.
In particular the ESTIMATE PERCENT parameter.
In 9i this defaulted to 100%, but in 10g it defaults
to AUTO_SAMPLE_SIZE.
And, as we understand it, the value of
AUTO_SAMPLE_SIZE is calculated for
EACH table based on information the optimizer holds
about the table,
and so the actual value for ESTIMATE PERCENT, for a
table in 10g,
could be anything from 1% to 100 % !
At the moment we have set ESTIMATE_PERCENT to 100%,
but we are wondering if this is over-kill and should
we just let
it default to AUTO_SAMPLE_SIZE ?
Does anybody have any thoughts to share about this
issue ?
Thanks in advance,
Best Regards,
Brian Thompson
Diodes Zetex Semiconductors Ltd.
______________________________________________________________________
Diodes Incorporated
E-MAILS are susceptible to interference. You should not assume that
the contents originated from the sender or Diodes Incorporated or that they
have been accurately reproduced from their original form.
Diodes Incorporated accepts no responsibility for information, errors or omissions in
this e-mail nor for its use or misuse nor for any act committed or omitted in connection with this communication.
If in doubt, please verify the authenticity with the sender.
_________________________________________________________
Offline 
Send Email