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 7.4.1.0.0 [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:
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 |