Can long lasting transaction fill up undo tablespace .
698658Jul 4 2012 — edited Jul 4 2012Hi,
Let's say we are on 9.2.0.8 and have long lasting transaction , I mean we started some update (1 row only but no commit/rollback) and do nothing for a couple of days .
So the amount of undo is minimal ,but we are having one undo slot used and 1 entry in undo transaction table .
Is that some kind of dangerous ? As far as I know undo is kind of circular buffer so we are fixing some upper end and preventing new transaction from using lower 'end' .
Please elaborate . I've noticed some GUI reports such situation as undo 100% full , not sure if thats ok .
Regards
GregG