My Oracle Support Banner

Master Note: Optimizer Statistics (Doc ID 1369591.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Oracle Database - Standard Edition - Version 9.0.1.0 and later
Oracle Database - Personal Edition - Version 9.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.

Purpose

This document outlines the primary information sources regarding all aspects of Statistics gathering for the Cost Based Optimizer (CBO).

Questions and Answers

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
Purpose
Questions and Answers
 How to Gather Optimizer Statistics
 Troubleshooting Issues Following Statistics Gathering
 Best Practices
 Automated Statistics Collection
 Automatic Detection of Un-Gathered/Stale Objects
 Backing up and Restoring Statistics
 Transferring Statistics to a different database
 Dictionary and Fixed Table Statistics
 System Statistics
 Statistics Frequently Asked Questions
 Checking for the presence of Statistics
 Pending Statistics
 Miscellaneous Topics
References

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