Re: rollback segments

Tablespace storage is only for objects you build in the tablespace that you do not specify the storage information. Since this is a rollback tablespace you should only be creating rollback objects, therefore it should be sized according to your rollback segments. In most cases when building a rollback segment you will specify initial, next, minextents ex.. so it will never use the tablespace settings.

Lets just say you did not specify any default setting in your tablespace. Oracle will then use the system default storage for objects created without specifying the storage clause. Oracle 7.3.3 default is initial 5 oracle blocks, next 5 oracle blocks, minextent 1, maxextents 121, pctincrease 50. So if you had a 2 k block size, which is the default size, then initial will be 10k, next 10k.

NOTE: on rollback segments you have to have pctincrease set to 0%. Also the OPTIMAL command is only valid for rollback objects it does not apply for other objects.

When building you rollback segments you should have 20 min extents. Your optimal should be min extents * initial size. Your next extent should be the same size as you initial. You should have one rollback segment for every 10 concurrent users.

Hope this helps.

Bill

--
William Dangren
Navis Enterprises
407.348.6401
800.219.0207 Received on Thu Apr 29 1999 - 11:03:18 CDT