Re: Are any of you guys managing rollback segments manually?

Im with you. I still see it occasionally, but when I do I tell them to go with undo.

On Tue, Aug 23, 2016 at 9:03 AM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> 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
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l