Thank you so much Jonathan. As you rightly mentioned , the Shrink of
specific rollback segment seems to be the best work around to get away in
this situation. i'm going to try it now. Thanks.
On Thu, Apr 1, 2021 at 5:07 PM Jonathan Lewis <jlewisoracle@xxxxxxxxx>
wrote:
Follow-up to my previous comments about dropping or affecting the size of
undo segments. Read MOS nod 1580182.1
The basic comment is that you can hit this problem if you have very long
running transactions and a very large undo retention - and it probably
needs a reasonable level of concurrency as well, but that's not stressed.
It is possible to set a debug parameter that allows you to shrink undo
segments by name - details in the note.
It seems to work.
Regards
Jonathan Lewis
