SQL stats can be maintained automatically in OE release 12.0 by a special server process. Thank you very much Richard ! What is the threshold when that "special" server process decides to automatically rebuild statistics? Is that 5% changed? And will it be described in details in 12.0 documentation ? I had some problems with that process in Oracle. When a new partition starts on the 1-st day of the month statistics that is automatically generated is off, because there is not enough data in a partition. Oracle has a way to copy statistics, so I was copying statistics from the previous month partition to overwrite the generated one on the 1st and 2d day of the month. So there may be issues with automatically generated statistics ( like with autonomous driving cars)
