I was having a discussion with a guy about improving data load speeds and
he was asking me about creating a large rollback segment and how I would
handle it. I was a bit taken aback because I haven't manually managed
rollback segments in a long, long time.
So, I'm curious if this is still "a thing"? Managing rollback segments
manually especially in regard to large data loads?
If so, I'd like to understand why managing rollback segments manually makes
more sense than using a dedicated UNDO tablespace and letting Oracle manage
the rollback segments?
I've been googling some this morning and I see some bits and pieces here
and there but I don't see any use cases where managing rollback segments
manually makes sense to me. (So I'm trying to put 2+2 together in my own
mind)
Regards,
Chris
