My Oracle Support Banner

How to Change Default Parameters for Gathering Statistics in Oracle 11g or Later (Doc ID 1493227.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 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!


In this Document
Goal
Solution
 Procedures for Changing Default Parameters
  SET_GLOBAL_PREFS
 SET_TABLE_PREFS
 SET_SCHEMA_PREFS
  SET_DATABASE_PREFS
 Available Parameters 
 CASCADE
 DEGREE
 ESTIMATE_PERCENT
 METHOD_OPT
 NO_INVALIDATE
 GRANULARITY
 PUBLISH
 INCREMENTAL
 STALE_PERCENT
 AUTOSTATS_TARGET
 Resetting Parameters to Their Default Values
 Retrieving values for Parameters
 DBMS_STATS.GET_PREFS
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.