Table of Contents
- Title and Copyright Information
- Preface
- 1 OSM System Administration Overview
- 2 Changing GUI Application Appearance and Functionality
- 3 Setting Up OSM Security
- 4 Configuring OSM with oms-config.xml
- 5 Configuring the Task Processor
-
6
Managing the OSM Database Schema
- Implementing a Strategy for OSM Information Lifecycle Management
- Creating Tablespaces
- Using Partitioning
- Order Purge Strategies
- Partitioning Realms
- Cartridge Management Strategy
- Sizing Partitions
- Online vs. Offline Maintenance
-
Managing Order Data
- Adding Partitions (Online or Offline)
- Using Row-Based Order Purge
- Using Partition-Based Order Purge
- Reclaiming Unused Space in Volatile Tables
- Order Purge Policies
- Auditing and Monitoring Order Purges
- Managing Exchange Tables for Partition-Based Order Purge
- Estimating Partition Disk Space (Online or Offline)
- Managing Cartridges
-
Configuration Parameters
- range_partition_size
- subpartitions_number
- default_xchg_capacity
- xchg_retained_orders_thres
- degree_of_parallelism
- degree_of_parallelism_rebuild_indexes
- degree_of_parallelism_rebuild_xchg_indexes
- purge_job_class
- parallel_execute_chunk_size
- partition_auto_creation
- purge_policy_rebuild_unusable_indexes
- purge_policy_purge_related_orders_independently
- purge_policy_consolidate_partitions
- purge_policy_time_to_close_wait
- purge_audit_retention_days
- deferred_segment_creation
- purge_commit_count
- About PL/SQL API
-
PL/SQL API Reference
- Setup and Tuning Procedures
-
Maintenance Procedures and Functions
- om_part_maintain.add_partition (Offline Only)
- om_part_maintain.add_partitions (Offline Only)
- om_part_maintain.drop_partitions (Offline only)
- om_part_maintain.drop_empty_partitions (Online or Offline)
- om_part_maintain.purge_partitions (Online or Offline)
- om_part_maintain.purge_entire_partition (Online or Offline)
- om_part_maintain.estimate_ptn_purged_space (Online or Offline)
- om_part_maintain.purge_xchg_bck_tables (Online or Offline)
- om_part_maintain.purge_xchg_prg_tables (Online or Offline)
- om_new_purge_pkg.delete_order (Online or Offline)
- om_new_purge_pkg.purge_orders (Online or Offline)
- om_new_purge_pkg.schedule_order_purge_job (Online or Offline)
- om_new_purge_pkg.select_orders (Online or Offline)
- om_new_purge_pkg.purge_selected_orders (Online or Offline)
- om_new_purge_pkg.stop_purge (Online or Offline)
- om_new_purge_pkg.resume_purge (Online or Offline)
- Advanced Procedures
- Troubleshooting Functions
-
Recovery Procedures
- om_part_maintain.equipartition (Offline only)
- om_part_maintain.purge_orphan_order_data (Online or Offline)
- om_part_maintain.rebuild_unusable_indexes (Online or Offline)
- om_part_maintain.rebuild_index (Online or Offline)
- om_part_maintain.sys$undo_restore_table (Offline)
- om_part_maintain.sys$undo_restore_orders (Offline)
- Database Reference
- Troubleshooting and Error Handling
- Performance Tuning
- Database Terms
-
7
Managing Optimizer Statistics
- About Optimizer Statistics
- Gathering Optimizer Statistics
- Preparing a New Partition
- Configuring a Partition When It Is No Longer the Active Partition
- Optimizer Statistics Error Handling Using Datapump
- Optimizer Statistics Management Performance Tuning
- Optimizer Statistics Management PL/SQL API Reference
- 8 Backing Up and Restoring OSM Files and Data
- 9 Monitoring and Managing OSM
-
10
Exporting and Importing OSM Schema Data
- About Exporting and Importing OSM Schema Data
- Exporting and Importing the OSM Model Data Only
- Exporting and Importing the OSM Model and a Single Order
- Exporting and Importing a Range of Orders and the OSM Model
- Exporting and Importing a Range of OSM Orders Only
- About Order Export Queries
- Changing PAR File Parameters
- About Import Parameters
- Troubleshooting Export/Import
- 11 Configuring Time Zone Settings
-
12
Troubleshooting OSM
- Information You Need for Troubleshooting
- General Checklist for Resolving Problems
-
Diagnosing Some Common Problems with OSM
- Cannot Log in or Access Certain Functionality
- System Appears Slow
- Error: "Java.lang.StackOverflowError" when Using Task Web Client
- Coherence Configuration Error: [STUCK] ExecuteThread
- Unexpected Logout from Web Client
- Error: "Login failed. Please try again."
- Automation Plug-ins Are Not Getting Called
- Delayed JMS Messages
- Error Message For Events From a JMS Topic in a Cluster
- JMS Message Delivery Failure
- Unexpected Values for JMS Properties
- Too Many Open Files
- Problems When Running Multiple WebLogic Domains on One Host
- Proxy Fails on a Clustered System
- Unable to Bring Up Managed Server After Database Failure
- Orders Are Not Being Created on a Clustered System
- JBoss Cache Timeouts
- OSM Fails to Process Orders Because of Metadata Errors
- Error: "No Backend Servers Available"
- DataDictionary Expansion Level
- Quick Fix Button Active During Order Template Conflicts in Design Studio
- Cannot Create New Orders on a New Cartridge Version
- Error: "exact fetch returns more than requested number of rows"
- Error: "unique constraint violated"
- Exceptions When Purging is in Progress
- Error: "Ignoring partition"
- Accessing Thread Dumps in OSM Cloud Native
- Getting Help with OSM Problems
- 13 OSM Log Messages
-
14
Using the XML Import/Export Application
- About the XML Import/Export Application
- About Using the XML Import/Export Application
- About XML Import/Export Batch Scripts and Ant Commands
- Configuring the XML Import/Export Environment Files
- Configuring the config.xml File XML Import/Export Nodes and Elements
- About Importing and Exporting Metadata
- About Purging MetaData and Data
- About Migrating Orders
- About Validating the Metadata Model and Data
- About Creating a Graphical Representation of the Metadata Model
- A OSM Credential Store API Command Reference
- B Tools for Performance Testing, Tuning, and Troubleshooting
- C OSM Installed Components