Defragmenting Objects with Alter Shrink Method (ie. After Vouchers Deletion)
(Doc ID 1347102.1)
Last updated on JUNE 28, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later Oracle Communications Network Charging and Control - Version 3.1.0 and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Information in this document applies to any platform.
Goal
This document explains how to defragment objects. While this can be applied broadly, this document is particularly focused on OCNCC products family (Oracle Communication Network and Charging Control).
User MUST have Oracle Server Enterprise Edition 10g onwards to be able to apply commands referred in this document (coalesce, shrink), except for the Pre-requisites section (see note).
Some tables and indexes can be fragmented when a huge deletion has been performed as in Doc 1269895.1. This is particularly the case after Vouchers deletion in ccs_voucher_reference and be_vouchers. After this operation, the tablespace usage has not decreased due to fragmentation.
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!