Re: rollback segment initial size

Hi Daud,

Because it is ...

OK, you don't like that answer, let me explain.

With LMT, pretty well all storage parameters specified at the object level are irrelevant in that the storage characteristics of the LMT take precedence. The only exception to this rule is when an object is first created in that the *object* storage clause determines the *initial* size of an object.

Basically the object storage clause values of INITIAL, NEXT, PCTINCREASE and MINEXTENTS are used to calculate the *initial size of the object*. Note that the MINEXTENTS value doesn't necessarily mean that many extents are actually created, as it's the UNIFORM SIZE or the AUTOALLOCATE value of the LMT that actually determines this.

Therefore Oracle documents the following: INITIAL = the sum as calculated above, NEXT is either the UNIFORM SIZE or the value as determined by AUTOALLOCATE, PCTINCREASE is always 0, MINEXTENTS is 1 and MAXEXTENTS is unlimited.

Just the way it is ...

Cheers

Richard

"Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0209180149.1a042628_at_posting.google.com...
> I created a LMT tablespace with uniform extent 512K for rollback
> segments.
> I then created a rollback segment.
>
> create rollback segment rb01 tablespace RBS storage (initial 512K next
> 512K minextents 6)
> /
>
> Ok...when I checked it has 6 extents.
> However, minextents is 1 and initial is set to 512*6 K.
> Why is that? Why not minextents = 6 and initial = 512K like what I
> said it should be when I created it?
>
> rgds
> Daud
Received on Wed Sep 18 2002 - 07:53:50 CDT