System Statistics: Scaling the System to Improve CBO optimizer
(Doc ID 153761.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 188.8.131.52 and later Oracle Database - Standard Edition - Version 184.108.40.206 and later Oracle Database - Personal Edition - Version 220.127.116.11 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: