No disk space is released in Oracle Server after running the Cleanup Submitted Tasks

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

In an environment where Oracle is used as the Task Persistence database, the "Cleanup Submitted Tasks" process runs successfully without any issues, but no disk space is freed up afterward.

Environment

Identity Manager: 14.4, 14.5

Oracle DB as Task Persistence repository.

 

Cause

In Oracle, deleting rows from a table won't automatically release any disk space.

Resolution

Please perform a full backup before running any queries against your DB.

To free up disk space, run the Shrink command below. 

--Shrink a LOB segment: 
ALTER TABLE OBJECT12_5 MODIFY LOB (OBJECT) (SHRINK SPACE); 

--Recover space:
ALTER TABLE OBJECT12_5 shrink space; 

 

Additional Information

In case you have any problem with Cleanup Submitted Tasks while removing old data, see the Technical document below:

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-manager/14-5/administrating/system-management/cleanup-submitted-tasks/cleanup-submitted-tasks-tab.html