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 03, 2020
Applies to:Oracle E-Business Suite Technology Stack - Version 126.96.36.199 to 12.2 [Release 11.5.10 to 12.2]
Oracle Applications DBA - Version 188.8.131.52 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.
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 & APPLICATION
For Apps DBAs looking for a method to reclaim unused space in a tablespace by reducing the size of the datafiles.
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.
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
|SCOPE & APPLICATION|
|IDENTIFY/VERIFY THE PROBLEM|
|Start analyzing each segments individually|
|There are a few possible scenarios:|
|RELOCATE SEGMENT / RESET HIGH WATERMARK (HWM)|
|Exceptions: "Don't use MOVE/REBUILD/SHRINK"|
|Based on the segment type take one of the actions:|