Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why is my UNDO not releasing the space?

unknown-1052419Feb 16 2014 — edited Feb 16 2014

Hi all,

11.2.0.1

aix6

We keep on  running the same batch jobs, and app  everyday.

I want to check how much UNDO  does my database used in a day.

So I reset my undots1 drop it, created a new undots2 for a fresh restart.

Then I monitored the usage of UNDO at the end of the first day. It reached 6Gb usage.

To my understanding, I thought it will just reuse this size everyday and will not extend anymore.

But when I check the next next day, it grows to 7Gb, and the next day as well.

Does my UNDO keep on growing forever?

What happened if I set my UNDO_RETENTION = 0? so it will release the used space right away?

Is this possible? How do I set my UNDOTS to release fast once I commit the transaction?

Thanks all,

pK

This post has been answered by Suntrupth on Feb 16 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2014
Added on Feb 16 2014
13 comments
2,454 views