rollback maxextents

From: Charles J. Fisher <cfisher_at_rhadmin.org>
Date: Wed, 08 Oct 2003 15:26:06 GMT
Message-ID: <Pine.BSO.4.53.0310081015480.15473@bart.rhadmin.org>

I just moved some 8.1.7 rollback segments to an LMT.

The LMT was created with

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M. I created the rollback segments with

STORAGE (INITIAL 16M NEXT 16M MINEXTENTS 2 MAXEXTENTS 8). Why do I see the following?

SQL> select segment_name, initial_extent, next_extent, max_extents 2 from dba_rollback_segs where tablespace_name='RBSL';

SEGMENT_NAME                   INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS
------------------------------ -------------- ----------- -----------
R01                                  33554432    16777216       32765
R02                                  33554432    16777216       32765
R03                                  33554432    16777216       32765
R04                                  33554432    16777216       32765
R05                                  33554432    16777216       32765
R06                                  33554432    16777216       32765

6 rows selected.

I am also unable to modify MAXEXTENTS for these rollback segments.

SQL> alter rollback segment r02 offline;

Rollback segment altered.

SQL> select status from dba_rollback_segs where segment_name='R02';

STATUS

OFFLINE SQL> alter rollback segment r02 storage (maxextents 8); alter rollback segment r02 storage (maxextents 8) *
ERROR at line 1:
ORA-25150: ALTERING of extent parameters not permitted

(I am able to modify the OPTIMAL parameter, however.)

   / Charles J. Fisher                   |"How many who came into this world /
  /  cfisher_at_rhadmin.org                 | with me have already left it!"   /
 /   http://rhadmin.org                  |       -Marcus Aurelius          /
---------------------------------------------------------------------------

Received on Wed Oct 08 2003 - 10:26:06 CDT