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

Task Persistence in Oracle database, the Cleanup Submitted Tasks is running without problem but no disk space is being released after that.

 

 

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. 

 

ALTER TABLE OBJECT12_5 MODIFY LOB (OBJECT) (SHRINK 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