Generally speaking it is more a question of what works for you.That is defined
by the quality of the execution plans.
In the world of the optimizer no such thing as the absolute truth does exist.
There are limited statistics and some basic assumnptions available for the
optimizer to generate plans to all the sql in all Oracle databases worldwide.
That it works as good as it does is close to a miracle.
----Ursprüngliche Nachricht----
Von : carlospena999@xxxxxxxxx
Datum : 25/03/2019 - 05:56 (MN)
An : oracle-l@xxxxxxxxxxxxx
Betreff : System stats
List,
I was reading up on system stats and came across this link:
https://blogs.oracle.com/optimizer/should-you-gather-system-statistics
Here are some of the things the author says:
1. "if you are at a decision point and you need to choose whether to gather
them or not, then in most cases you should use the defaults and
not gather system statistics."
Doesnt setting systems help a lot these days esp with faster IO devices. Do
the listers collect system stats in your environments, test. prod, etc?
2. "there is at least
some management or procedural overhead required to maintain them"
'Maintaining' stats? I thought once we set the system stats we leave it out
there forever without touching it?
Thanks all,
CP