Re: Best way to call dbms_stats

"M.a.x G.e.decke" <spam_at_gedecke.de> wrote in message news:ajssui$124k$1_at_redenix.uni-muenster.de...
> please be nice to a newbie and don't hit me with too many bad comments
:-).
> how do you gather your statistics? are there any globals "do's" and
> "don'ts"?

Rules:
Do

1. Collect regularly

Don't

2. Collect stats on SYS or SYSTEM.

Opinion:

Do.

1. Collect as much as time allows.
2. Collect as frequently as time allows.
3. Have a test system on which to try out more or less extensive stats and their effect.

Don't

1. Assume that what works for one db and app will work equally well for a second.
2. Assume that collecting stats and leaving the optimiser to get on with it absolves you from tuning responsibility.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************.