relation between undo_retention and undo tablepsace size
Hello,i am on 10.2.0.3.
Can someone please clear this things a little bit.
Let's say that i have one SQL that is doing inserts or updates and this have execution time of 30 minutes,
and my undo_retention parameter is set to 20mins, undo_management=auto, and undo tablespace of 30GB of which is curently taken only 1GB,
will this insert fail with ora-1555 snapshot too old or not ?
Is undo_retention the only thing that determines how long query can be run or i can focus on undo tablespace size also if there is enough space in it ?