Undo tablespace not release
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? :confused: 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