Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> query on dba_rollback_segs shows different initial extent

query on dba_rollback_segs shows different initial extent

From: Leigh Gold <intan_5ee_at_yahoo.com>
Date: Fri, 23 Nov 2001 09:51:12 -0700
Message-ID: <9tlugf$ad3$1@news3.cadvision.com>


I have created a rollback tablespace with rollback segments like this:

create tablespace RBS1
datafile 'C:\ORACLE\ORADATA\ORCL\RBSLM1.dbf' size 409664k reuse
autoextend off
extent management local uniform size 1m;

create public rollback segment rbs01
storage (initial 1024k next 1024k optimal 25m minextents 25 maxextents 100) tablespace rbs1;
create public rollback segment rbs02
storage (initial 1024k next 1024k optimal 25m minextents 25 maxextents 100) tablespace rbs1;
create public rollback segment rbs03
storage (initial 1024k next 1024k optimal 25m minextents 25 maxextents 100) tablespace rbs1;
create public rollback segment rbs04
storage (initial 1024k next 1024k optimal 25m minextents 25 maxextents 100) tablespace rbs1;

alter rollback segment rbs01 online;
alter rollback segment rbs02 online;
alter rollback segment rbs03 online;
alter rollback segment rbs04 online;

However, when I did a query on dba_rollback_segs after the creation, I get this:

SEGMENT_NAME              INITIAL_EXTENT    NEXT_EXTENT      MIN_EXTENTS
------------------------------ --------------               -----------     
            -----------
SYSTEM                                     57344                       57344
2
RBS01                                   26214400                   1048576
1
RBS02                                   26214400                   1048576
1
RBS03                                   26214400                   1048576
1
RBS04                                   26214400                   1048576
1

Is this what it should be? I was expecting to see initial_extent = next = 1028576 and min_extents = 25.

Am I missing something?

Thanks,

Leigh Received on Fri Nov 23 2001 - 10:51:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US