RE: Rollback Segments Errors

From: yong huang <yong321_at_yahoo.com>
Date: Fri, 10 Nov 2000 12:43:57 -0800 (PST)
Message-Id: <10676.121791@fatcity.com>

Hi,

The documentation says we can't change minextents. But I don't have any problem changing it to anything other than 1:

SQL> select segment_name, min_extents from dba_rollback_segs;

SEGMENT_NAME                   MIN_EXTENTS


------------------------------ -----------

SYSTEM                                   2
R01                                      2
R02                                      2
R03                                      2
R04                                     10

SQL> alter rollback segment r04 storage (minextents 2);

Rollback segment altered.

SQL> alter rollback segment r04 storage (minextents 20);

Rollback segment altered.

SQL> alter rollback segment r02 storage (minextents 13);

Rollback segment altered.

SQL> select segment_name, min_extents from dba_rollback_segs;

SEGMENT_NAME                   MIN_EXTENTS


------------------------------ -----------

SYSTEM                                   2
R01                                      2
R02                                     13
R03                                      2
R04                                     20

SQL> select * from v$version;

BANNER

Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.3.0.0 - Production
TNS for Solaris: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

and on another database:

SQL> select segment_name, min_extents from dba_rollback_segs;

SEGMENT_NAME                   MIN_EXTENTS


------------------------------ -----------

SYSTEM                                   2
RBS0                                     8
RBS1                                     8
RBS2                                     8
RBS3                                     8
RBS4                                     8
RBS5                                     8
RBS6                                     8
RBS7                                     8

9 rows selected.

SQL> alter rollback segment rbs7 storage (minextents 16);

Rollback segment altered.

SQL> alter rollback segment rbs7 storage (minextents 4);

Rollback segment altered.

SQL> alter rollback segment rbs7 storage (minextents 8);

Rollback segment altered.

SQL> select * from v$version;

BANNER

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for Solaris: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

Yong Huang
yong321_at_yahoo.com

you wrote:

Why cant I change the minextents?

SVRMGR> alter rollback segment r05

2> storage (minextents 10);
alter rollback segment r05
*
ORA-01570: MINEXTENTS must be no larger than the 4 extents currently allocated

SVRMGR> select
segment_name,tablespace_name,INITIAL_EXTENT,MIN_EXTENTS,MAX_EXTENTS

     2> from dba_rollback_segs
     3> where segment_name='R05';
SEGMENT_NAME    TABLESPACE_NAME     INITIAL_EX  MIN_EXTENT MAX_EXTENT


------------------------------ ------------------------------ ----------

---------- ----------
R05                            RBS                               1048576
3                1000

Thanks in advance.

Received on Fri Nov 10 2000 - 14:43:57 CST