Re: System stats

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_at_gmail.com
Datum : 25/03/2019 - 05:56 (MN)
An : oracle-l_at_freelists.org
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         

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 25 2019 - 09:43:11 CET