RE: Rollback Segments Errors

From: James Bullard <jbullard_at_onvia.com>
Date: Mon, 13 Nov 2000 05:12:18 -0800
Message-Id: <10679.121870@fatcity.com>

Rollback segments require a minimum of 2 extents. Is that the question that you are asking?

James

-----Original Message-----

From: yong huang [mailto:yong321_at_yahoo.com] Sent: Friday, November 10, 2000 12:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rollback Segments Errors

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.

Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: yong huang
  INET: yong321_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

Received on Mon Nov 13 2000 - 07:12:18 CST