UNDO tablespace increasing and not release space

UNDO tablespace increasing/growing and not release space

Applies to: 

Oracle Database 10gR2

Description:

Undo tablespace start growing abnormally. UNDO_RETENTION parameter is set to 900 seconds, but undo data did not release the space. After doing some research work I found the following solution:

Solution:

Set the following hidden parameter in init.ora file and check the free space in undo tablespace after 3-4 Hrs.

_smu_debug_mode=33554432

or

SQL> Alter system set "_smu_debug_mode" = 33554432;

 

Your comments, especially which will help us improve the functionality, will be greatly appreciated :)