Why Oracle task persistence database size isn't reducing upon running the Garbage Collector?

Document ID : KB000048977
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Run specific commands in Oracle in order to make the size reduction take effect.

Solution:

You might notice that the Oracle task persistence database size remains unchanged after running the Garbage Collection.

The Garbage Collection is supposed to remove much data from the database so its size is expected to decrease.

On Oracle systems it is necessary to also execute some Oracle commands if you wish to reduce the amount of disk space after doing a clean up submitted tasks or garbage collection.

The commands to run are after the execution of the garbage collection are:

- ALTER TABLE OBJECT12_5 ENABLE ROW MOVEMENT;       
Table altered 
- commit;
Commit complete
- ALTER TABLE OBJECT12_5 MODIFY LOB (OBJECT) (SHRINK SPACE);
- commit;