Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> query on dba_rollback_segs shows different initial extent
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 10485761
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