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