How to Change Default Parameters for Gathering Statistics in Oracle 11g or Later
(Doc ID 1493227.1)
Last updated on OCTOBER 30, 2019
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Information in this document applies to any platform.
Goal
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:
<Document 725845.1> How to Change Default Parameters for Gathering Statistics in 10g
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!