If undo fills will it roll back updates/inserts?

Oracle Admins,

if my undo fills up, will it roll back updates and inserts? 

I've got a 170Gig database, I increased my SGA and now my undo has grown 20 
gigs in a week. I don't want to turn on auto extend. 

if this data warehouse tablespace fills up during my nightly cycle will it 
rollback my updates/inserts and kill this job? 

I looked at my undo and its 80% flashback data, 3 days worth of flashback, and 
yet my flashback is set to only 7 hours.

Any ideas,
thank you,
Patrick.




      

Other related posts: