My Oracle Support Banner

Improving Performance of OSM by increasing PCTFREE (Doc ID 2240041.1)

Last updated on DECEMBER 05, 2019

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

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