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

In this Document

Goal

Solution

References

---

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

Currently, the recommendations for gathering statistics for 12c are the same as for 11g. Please refer to the following 11g document for gathering recommendations:

Document 749227.1 How to Gather Optimizer Statistics on 11g

As soon as there are any new 12c specific changes are required, we will update this 12c specific article with those.

REFERENCES

NOTE:465787.1  - How to: Manage CBO Statistics During an Upgrade from 10g or 9i into 11g
NOTE:470316.1  - Using Actual System Statistics (Collected CPU and IO information)
NOTE:743507.1  - How to Benefit from Automatic Maintenance Tasks Following the Removal of the GATHER_STATS_JOB in 11g?
NOTE:756734.1  - 11g: Scheduler Maintenance Tasks or Autotasks
NOTE:44961.1  - Statistics Gathering: Frequency and Strategy Guidelines
NOTE:452011.1  - Restoring Table Statistics
NOTE:1226841.1  - How To: Gather Statistics for the Cost Based Optimizer
NOTE:1380043.1  - Selected Performance Related Seminars from Oracle Openworld (OOW)
NOTE:149560.1  - How to Collect and Display System Statistics (CPU and IO) for CBO use
NOTE:457926.1  - How to Gather Statistics on SYS Objects and 'Fixed' Objects?
NOTE:236935.1  - Global statistics - An Explanation
NOTE:237901.1  - Gathering Schema or Database Statistics Automatically in 8i and 9i - Examples