My Oracle Support Banner

Rebuilding Indexes in a OCNCC (Oracle Communication Network and Charging Control) Database (Doc ID 1328295.1)

Last updated on APRIL 30, 2024

Applies to:

Oracle Communications Network Charging and Control - Version 3.2.0 and later
Oracle Communications Convergent Charging Controller - Version 6.0.0 and later
Oracle Solaris on SPARC (64-bit)

Purpose

This article describes how to determine if rebuilding indexes could be necessary on OCNCC (Oracle Communication Network Charging Control) or OCCCC (Oracle Communications Convergent Charging Controller) products.

It also informs the OCNCC/OCCCC system administrator about the implications of such an operation.

Scope

NCC system administrator looking to maintain the indexes used by the NCC application.

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
 Introduction
 A few words on : TableSpace, Data File, Table, Index, Segment, Extent
 Index, B-tree and ... fragmentation ?
 Is Index Fragmentation the right problem ?
 Hypothesis
 NCC tables and indexes
 Gather information on the table, index and the index tablespace
 Rebuilding the index
 Table Space usage
 List of NCC tables with volatile data
References

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