thanks suhen and all who
replied,
i droped the rollback segments and
re-created them as u told. it's fine now.
you were right that public rollback
segments are not required. i read document it said
If a database does not have the
Parallel Server option, public and private rollback segments are identical.
Therefore, you can create all public rollback segments. A database with the
Parallel Server option can also have only public segments
so, it's fine having public
Rollback segs.
thanks once again.
saurabh
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A href="mailto:Suhen.Pather_at_strandbags.com.au"
title=Suhen.Pather_at_strandbags.com.au>Suhen Pather
To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L
Sent: Friday, June 08, 2001 1:20 PM
Subject: RE: help for rollback
segments..
<FONT color=#0000ff face=Arial
size=2>Saurabh,
<FONT
size=2><SPAN
class=520275306-08062001>First of all no rollback segment should be in the
SYSTEM tablespace except SYSTEM rollback
segment.
<FONT
size=2><SPAN
class=520275306-08062001>This cause serious performance
problems.
<SPAN
class=520275306-08062001>
<SPAN
class=520275306-08062001>You would need to drop all the other rollback
segments that are in the SYSTEM tablespace and recreate them in
<SPAN
class=520275306-08062001>a
ROLLBACK tablespace.
<SPAN
class=520275306-08062001>
<FONT
size=2>To
drop rollback segment make sure no transactiosn are
running.
<FONT
size=2><SPAN
class=520275306-08062001>alter rollback segment SEGMENT_NAME
offline;
<SPAN
class=520275306-08062001>
<FONT
size=2><SPAN
class=520275306-08062001>drop rollback segment
SEGMENT_NAME;
<SPAN
class=520275306-08062001>
<FONT
size=2>For
each rollback segment and then recreate in the ROLLBACK
tablespace.
<SPAN
class=520275306-08062001>After creation the rollback segments will be offline.
You would need to set them online
individually.
<SPAN
class=520275306-08062001>
<FONT
size=2>The
reason why the rollback segments are offline is probably because they are not
included in your
<FONT
size=2><SPAN
class=520275306-08062001>init.ora file. Add all rollback segments to
this file and restart instance.
<SPAN
class=520275306-08062001>
<FONT
size=2>You
do not need to create the rollback segments as public rollback segments.
I think public Rollback
<FONT
size=2><SPAN
class=520275306-08062001>segments are used mostly for
OPS.
<SPAN
class=520275306-08062001>
<SPAN
class=520275306-08062001>Regards
<FONT
size=2><SPAN
class=520275306-08062001>Suhen
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 - 08:22:27 CDT
