Re: Optimal settings for rollback segs.

On 24 Apr 1996 17:22:01 GMT, "Brian P. Mac Lean" <brian.maclean_at_teldta.com> wrote:
>A rollback segment's OPTIMAL setting cannot be less than
>the combined space allocated for the minimum number of extents for the
>segment:
>
>(INITIAL + NEXT + NEXT + ... up to MINEXTENTS) bytes

We have a very interesting/annoying TAR open related to this. It seems that when we try to create a rollback segment with INITIAL=1M, NEXT=1M and MINEXTENTS=5 and OPTIMAL=5M the rollback segment is created, but with an actual size of  5302272 but an optimal size of 5242880.

Then when it's used, the client gets a ORA-01581: attempt to use rollback segment (6) new extent (3) which is being allocated.

--
Deborah Luik, Lead DBA        
ADP Claims Solutions Group                 Phone: (800) 366-4237 x2150
2010 Crow Canyon Place                     FAX  : (510) 866-4839
San Ramon, CA  94583 (USA)                 Email: dluik_at_sr.csg.com