Hi

I did a list of delete-commit statements which increased the undo tablespace till a certain point where it hits the unable to extend segment error.

What I do not understand is that when I tried to delete records which is about 1GB only but the undo tablespace have increased to 3.5GB! Is there a bug regarding the undo space being released after commit? My oracle version is 9.2.0.6. Thanks!

The undo related init parameters are:

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 10800
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS