Re: Rollback Segment Question

amerar_at_iwc.net wrote:

> I'd love to upgrade, but it is not my choice. :(
>
> Anyhow, I think I found the answer. The rollback segment tablespace
> was created as locally managed, with an extent size of 1MB. So, it
> does not matter how I try and size my rollback segment, the next extent
> will always be 1MB.
>
> So, I recreated the tablespace and segments with a larger extent size.
>
> Additionally, why when I create the initial and next extent sizes of
> 10MB does it show that the initial extent is 20MB?
>
> CREATE ROLLBACK SEGMENT RBS0
> TABLESPACE RBS
> STORAGE (INITIAL 10M NEXT 10M);
>
> select segment_name, initial_extent, next_extentfrom dba_rollback_segs;
>
> SEGMENT_NAME INITIAL_EXTENT NEXT_EXTENT
> ------------------------------ -------------------------
> ----------------------
> RBS0 20971520 10485760
>
> Should it not create the initial extent as 10MB???
>
> Arthur

A rollback segment has a minimum of two extents by default.

But unless you are in some neolithic version of Oracle such as 8i ... why are you using rollback segments at all?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)