HI ALL,
i've some confusion regarding
rollback segments. could anyone explain this information from my
database.
select * from
dba_rollback_segs revealed following stats..
SEGMENT_NAME OWNER
TABLESPACE INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA
STATUS------------- ------ ---------- ---------- ---------- ----------
---------- ----------
-------SYSTEM
SYS
SYSTEM
57344
57344
2
505 0
ONLINESYSROL SYS
SYSTEM
106496
106496
2
505 0
OFFLINERB0
PUBLIC RBS
106496
262144
2
121 0
ONLINERB1 PUBLIC
RBS
106496
262144
2
121 0
ONLINERB_TEMP SYS
SYSTEM
106496
106496
2
121 0
OFFLINERB2
PUBLIC SYSTEM
57344
262144
2
121 0
ONLINERB3 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB4 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB5 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB6 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB7 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB8 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB9 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB10 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB11 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB12 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB13 PUBLIC
SYSTEM
57344
262144
2
121 0
ONLINERB14 PUBLIC
SYSTEM
57344
262144
2
121 0
OFFLINERB15 PUBLIC
SYSTEM
57344
262144
2
121 0
OFFLINERB16 PUBLIC
SYSTEM
57344
262144
2
121 0
can anybody explain, why i get some
status as offline. will this extent allocation and other parameters ok. i 've
oracle 8.1.5 on NT, these stats are from my test database.
why are they in system tablespace.
i've two rollback tablespace of size 15 and 20 mb resp.
should they be in system or in
rollback.
if yes, how to change their default
tablespace.
pls help me in deciding
that.
thanks in advance.
saurabh
Received on Fri Jun 08 2001 - 02:32:41 CDT
