Re: Understanding Rollback Segment Sizes

> As Brian indicated, the "set it and forget it" aspect of Undo
> tablespaces looks like the way to go. Now the only issue is convincing
> my management that we should do it that way instead of the way our five
> other Oracle sites are configured,

That should be pretty easy...just tell them that you save man hours by not having to manage the rollback segments any more.

 > and to see if our application
> developers can give me any info on whether our software ever explicitly
> tries to access a rollback segment, such as for month-end processing or
> cleanup utilities.
>

You can set the UNDO_SUPPRESS_ERRORS intialization parameter to TRUE. If someone explicitly does "SET TRANSACTION USE ROLLBACK SEGMENT...", it will be ignored. The default for this parameter is FALSE, in which case, the SET TRANSACTION statement would result in an error.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown