My Oracle Support Banner

New OSM Database Optimizer Statistics Management (Doc ID 1925539.1)

Last updated on APRIL 02, 2024

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 to [Release 7.2 to 7.4.1]
Information in this document applies to any platform.
This version of the document currently applies to the following OSM releases:

For information on earlier releases, please refer to Best Practices for Managing Optimizer Statistics for Oracle Communications Order and Service Management (OSM) (Doc ID 1662447.1)


This document provides best practices for managing Oracle Database optimizer statistics for Oracle Communications Order and Service Management (OSM) 7.


This document is targeted to system integrators and database administrators (DBAs) who must work together to manage database optimizer statistics in order to prevent performance issues. DBAs must monitor statistics on an on-going basis and be prepared to address inefficiencies before they cause performance problems.


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
 Managing Optimizer Statistics
 Online Statistics Management
 Automatic Database Optimizer Statistics Collection
 Gathering Fixed Object Statistics
 Gathering System Statistics
 Gathering Cartridge Metamodel Statistics
 Configuring Order Table Volatility
 Enabling Incremental Statistics
 Gathering High Volatility Table Statistics
 Gathering Low Volatility Table Statistics
 Populating Empty Partition Statistics
 Using Statistics from Another Partition
 Using Statistics from a Statistics Table
 Using Statistics from Another System
 Locking and Unlocking Partition Statistics
 Locking Partition Statistics
 Unlocking Partition Statistics
 Optimizer Statistics Management Error Handling
 Datapump Jobs
 Optimizer Statistics Management Performance Tuning
 Parallel Collection
 Cursor Invalidations
 Optimizer Statistics Management PL/SQL API Reference
 Setup and Tuning Procedures
 Maintenance Procedures
 Advanced Procedures
 Troubleshooting Procedures
 Recovery Procedures
 Additional References

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