* How to Gather Optimizer Statistics on 11g
(Doc ID 749227.1)
Last updated on SEPTEMBER 20, 2022
Applies to:
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 Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Backup 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 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!