System Statistics: Scaling the System to Improve CBO optimizer
(Doc ID 153761.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later Oracle Database - Standard Edition - Version 126.96.36.199 and later Oracle Database - Personal Edition - Version 188.8.131.52 and later Information in this document applies to any platform.
Purpose of this note is to explain the impact of gathering system statistics on the CBO optimizer and to give DBA guidance to use this functionality. Most recent perspective is that system stats does not necessarily need to be gathered per following blog: