-
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? 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|