My Oracle Support Banner

New OSM Database Optimizer Statistics Management (Doc ID 1925539.1)

Last updated on OCTOBER 15, 2018

Applies to:

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

7.2.0.10.X
7.2.2.5.X
7.2.2.6.X
7.2.2.7.X
7.2.4.1.X
7.2.4.2.X
7.3.0.X.X
7.3.1.X.X
7.3.5.X.X

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)

Purpose

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

Scope

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.

Details

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
Purpose
Scope
Details
 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
 om_db_stats_pkg.lock_volatile_order_stats
 om_db_stats_pkg.unlock_volatile_order_stats
 om_db_stats_pkg.set_table_prefs_incremental
 om_db_stats_pkg.set_table_volatility
 Maintenance Procedures
 om_db_stats_pkg.gather_cartridge_stats
 om_db_stats_pkg.gather_order_stats
 om_db_stats_pkg.gather_volatile_order_stats
 om_db_stats_pkg.copy_order_ptn_stats
 om_db_stats_pkg.lock_order_ptn_stats
 om_db_stats_pkg.unlock_order_ptn_stats
 Advanced Procedures
 om_db_stats_pkg.export_order_ptn_stats
 om_db_stats_pkg.import_order_ptn_stats
 om_db_stats_pkg.expdp_order_ptn_stats
 om_db_stats_pkg.impdp_order_ptn_stats
 Troubleshooting Procedures
 om_db_stats_pkg.lstj_copy_order_ptn_stats
 Recovery Procedures
 om_db_stats_pkg.remj_copy_order_ptn_stats
 Additional References
References

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