My Oracle Support Banner

Primary Note: Optimizer Statistics (Doc ID 1369591.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database - Standard Edition - Version and later
Oracle Database - Personal Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


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
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

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