Re: Rollback segment size

Hi Frank,
One Mb is where I start.
Extents unlimited is a bad idea. If you do that you will hit the limits of the tablespace and one or more rollback segments will grow hindering others. You could set the tablespace to autoextend, but then you will run -unless you have plenty of disk space- in other nightmares. You could consider setting optimal, to 4 times the size of the initial extent. In this case rollback segments will shrink when unused and deallocate unnecessary space.

Hth,

Sybrand Bakker, Oracle dba

Frank Calfo wrote in message <01be9ca3$a0db9520$e4010180_at_frank>...
>Our database was created with 4 rollback segments with initial and next
>extent size of 128K.
>I've noticed that highwater mark on them is approaching 30 MB and one just
>hit max extents limit.
>
>In our case, seems like 128K for next extent is rather small.
>
>Could I make it as large as 1MB or is that generally too large for a
>rollback segment?
>
>Also, is settting unlimited extents on rollback a good or bad idea?
>
>Thanks.
>
Received on Wed May 12 1999 - 16:40:50 CDT