Improving Performance of OSM by increasing PCTFREE
(Doc ID 2240041.1)
Last updated on APRIL 09, 2024
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.
Purpose
This document explains how to change the PCTFREE on an OSM Database to increase the performance.
The performance of some inserts statements in OSM can be improved by reducing the index concurrency by increasing the PCTFREE. The reason for the index concurrency is frequent block splits when inserting new rows into the index. When inserting a new row into an index the session needs to find space in an index block, if it can't find space it will initiate an index block split which can result in concurrency.
Scope
This document is applicable to OSM 7.2.x to 7.3.1.x.
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 |
| Changing the Default Index PCTFREE for New Partitions Added in the Future |
| Changing the Index PCTFREE for ACTIVE and AVAILABLE (Empty) Partitions |
| Checking the index PCTFREE on Existing Partitions |