Why can I change rollback segs minextents? (Was: Rollback Segments Errors)

From: yong huang <yong321_at_yahoo.com>
Date: Tue, 14 Nov 2000 11:27:46 -0800 (PST)
Message-Id: <10680.122029@fatcity.com>

Hi, James,

No. I was responding to people that say they can't change the min_extents of rollback segments. Oracle manual also says we cannot change it (http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem16.htm#2052313). But why can I change it? Is this something Oracle changed from an older version but forgot to change the documentation? People are not testing and still believe how it used to behave?

Yong Huang
yong321_at_yahoo.com

James wrote:

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

James

-----Original Message-----
Sent: Friday, November 10, 2000 12:51 PM To: Multiple recipients of list ORACLE-L

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

__________________________________________________

Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays! Received on Tue Nov 14 2000 - 13:27:46 CST