How to Change Default Parameters for Gathering Statistics in Oracle 11g or Later
Last updated on JUNE 28, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
This document provides information regarding the default parameters for gathering optimizer statistics in Oracle 11g or later and outlines different possible values for these parameters and how to change them. These default parameters are used when automatic gathering statistics within a maintenance window and define how these statistics will be collected.
For similar information on Oracle 10g, see:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms