My Oracle Support Banner

How to Gather Optimizer Statistics on 12c (Doc ID 1445302.1)

Last updated on MARCH 01, 2024

Applies to:

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

Goal

This Document outline the recommended method to gather a standard set of optimizer statistics for use by the Cost Based Optimizer under Oracle 12c. For other versions see:

<Document 1226841.1> How To: Gather Statistics for the Cost Based Optimizer

 

NOTE: There is a presentation entitled "Best Practices for Managing Optimizer Statistics" available in:

<Document:1380043.1> Selected Performance Related Seminars from Oracle Openworld

Which also addresses and provides specific tips on this subject.

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
References

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