Re: Reusing name of rollback segment

In article <917tle$gad$1_at_nnrp1.deja.com>,   Grange Man <odindba_at_my-deja.com> wrote:
> Someone told me recently that if one drops and recreates a rollback
> segment (say to change its size), that it should be given a new name,
> not the name it used to have.
>
> Is there any basis for this?
>
> Thanks.
>

I am guessing that person based his reasoning on how Oracle used to handle and may still handle entries in sys.undo$ which after the creation, dropping, and recreation of the same rollback segment name would have multiple entries for the segment. It was possible to fill the table which had only 50 (if I remember correctly) slots and then Oracle would refuse to create more rbs segments. There was an init.ora parameter that you had to set to allow for more entries, bounce your instance, and then continue.

I do not think there is any problem with reusing the same name. We did it dozens of times before we ran into the need to use the init.ora parameter. If you set optimal parameter then once you resize them you are unlikely to have to drop and recreate them again so even if there were a potential problem with reusing the name it is not likely to be a problem.

I hope this helps you make a decision.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/