My Oracle Support Banner

* How to Gather Optimizer Statistics on 11g (Doc ID 749227.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Database - Personal Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database - Standard Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle E-Business Suite Performance - Version 12.1.3 to 12.1.3 [Release 12.1]
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 11g. 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!

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