My Oracle Support Banner

E-Business Suite Database For Applications Technology Stack Reclaiming Unused Space In A EBS Tablespace By Reducing The Size Of The Datafiles (Doc ID 303709.1)

Last updated on OCTOBER 18, 2018

Applies to:

Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Oracle Applications DBA - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2Cloud]
Oracle Applications Manager - Version 12.1.3 to 12.2 [Release 12.1 to 12.2Cloud]
Oracle Order Management - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Purpose

E-Business Suite Applications Technology Stack, Database For Applications Technology related issues

 

 

 

 

 

 

This article provides suggestions on reclaiming unused space in datafiles of applsysd tablespace in an Oracle E-Business Environment. Although it was focused on APPLSYSD tablespace, same rules are valid for any other tablespaces. The suggestions in this Note were collected from multiple incidents and was not tested fully in all possible apps_version/db_version combinations, however they should be applicable to all.

Scope

SCOPE & APPLICATION

For Apps DBAs looking for a method to reclaim unused space in a tablespace by reducing the size of the datafiles.

WARNING

You will be making changes to the Database.  Take a backup of the database before implementing the suggestions and test it first in either TEST or DEV Environment. It is also suggested to shutdown all the application processes.

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
 SCOPE & APPLICATION
Details
 IDENTIFY/VERIFY THE PROBLEM
 Start analyzing each segments individually
 There are a  few possible scenarios:
 RELOCATE SEGMENT / RESET HWM
 Exceptions: "Don't use MOVE/REBUILD"
 Based on the segment type take one of the actions:
 RESIZE DATAFILE
References

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