| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback Segs
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C34B6F.519F8E10
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
set transaction use rollback segment xxxx only works if it's the first
statement in your transaction, an easy way to make sure this is the case is
to issue a commit directly before issuing this statement.
I believe this has been a feature of Oracle since way back in version 7
(Correct me if I'm wrong).
=20
Hope this helps.
Cheers
Lee
-----Original Message-----
From: Fermin Bernaus [mailto:fbernaus_at_sammic.com]
Sent: 16 July 2003 09:09
To: Multiple recipients of list ORACLE-L
Subject: RE: Rollback Segs
=20
Which database version are you using? as long as I know, at least on Oracle 8.0.6 you can not specify which rollback segment a particular transaction should use. We disable all rollback segments and only enable those which we know won't make big updates / deletes crash. =20
-----Mensaje original-----
De: venkat Rama [mailto:techsqlca_at_yahoo.com]
Enviado el: mi=E9rcoles, 16 de julio de 2003 6:34
Para: Multiple recipients of list ORACLE-L
Asunto: Rollback Segs
Hi Friends,
=20
I have 150Gb database with 30 rollback segs with optimal settings!! for
normal operations no problems!! But we are doing massive updates for some of
big tables!! So we are using vb programs and connecting to the database thru
odbc dsn. My first question is how to set transaction use rollback segment
rbs_big? I tried to set as first stmt, but its not using rbs_big segment,
its using some other rollback segment. Is that good idea to make all my
rollback segs maxextents unlimited to avoid maxextents reached error?? I
have lot of rbs space nearly 10Gb. I saw one time, one of my rbs segment
extented 2gb and failed transaction with maxextents reached with 5m initial
and next, minextents 20 and optimal 100M.
=20
Any help will be appreciated
Thanks
venkat.
=20 =20 =20 =20
_____ =20
Do you Yahoo!?
SBC
<http://pa.yahoo.com/*http://rd.yahoo.com/evt=3D1207/*http://promo.yahoo.co=
m/s
bc/> Yahoo! DSL - Now only $29.95 per month!
This e-mail message (including any attachment) is intended only for the per=
sonal=20
use of the recipient(s) named above. This message is confidential and may b=
e=20
legally privileged. If you are not an intended recipient, you may not revi=
ew, copy or=20
distribute this message. If you have received this communication in error, =
please notify=20
us immediately by e-mail and delete the original message.
Any views or opinions expressed in this message are those of the author onl=
y.=20
Furthermore, this message (including any attachment) does not create any le=
gally=20
binding rights or obligations whatsoever, which may only be created by the =
exchange=20
of hard copy documents signed by a duly authorised representative of Hutchi=
son=20
3G UK Limited.
------_=_NextPart_001_01C34B6F.519F8E10
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D939005207-16072003><FONT face=3DArial color=3D#0000ff si=
ze=3D2>set=20
transaction use rollback segment xxxx only works if it's the first statemen=
t in=20
your transaction, an easy way to make sure this is the case is to issue a c=
ommit=20
directly before issuing this statement.</FONT></SPAN></DIV>
<DIV><SPAN class=3D939005207-16072003><FONT face=3DArial color=3D#0000ff si=
ze=3D2>I=20
believe this has been a feature of Oracle since way back in version 7 (Corr=
ect=20
me if I'm wrong).</FONT></SPAN></DIV>
<DIV><SPAN class=3D939005207-16072003><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D939005207-16072003><FONT face=3DArial color=3D#0000ff si=
ze=3D2>Hope=20
this helps.</FONT></SPAN></DIV>
<DIV><SPAN class=3D939005207-16072003><FONT face=3DArial color=3D#0000ff=20
size=3D2>Cheers</FONT></SPAN></DIV>
<DIV><SPAN class=3D939005207-16072003><FONT face=3DArial color=3D#0000ff=20
size=3D2>Lee</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT face=3DTah=
oma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Fermin Bernaus=20
[mailto:fbernaus_at_sammic.com]<BR><B>Sent:</B> 16 July 2003 09:09<BR><B>To:=
</B>=20
Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Rollback=20
Segs<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV> <SPAN class=3D277150407-16072003><FONT face=
=3DArial=20
color=3D#0000ff size=3D2>Which database version are you using? as long as=
I know,=20
at least on Oracle 8.0.6 you can not specify which rollback segment a=20
particular transaction should use. We disable all rollback segments and o=
nly=20
enable those which we know won't make big updates / deletes=20
crash.</FONT></SPAN></DIV>
<DIV><SPAN class=3D277150407-16072003><FONT face=3DArial color=3D#0000ff=
size=3D2></FONT></SPAN> </DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT face=3DT=
ahoma=20
size=3D2>-----Mensaje original-----<BR><B>De:</B> venkat Rama=20 [mailto:techsqlca_at_yahoo.com]<BR><B>Enviado el:</B> mi=E9rcoles, 16 de j= ulio de=20
2003 6:34<BR><B>Para:</B> Multiple recipients of list=20 ORACLE-L<BR><B>Asunto:</B> Rollback Segs<BR><BR></FONT></DIV>
<DIV>Hi Friends,</DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT face=3DArial size=3D2>I have 150Gb database with 30 rollback=
segs=20
with optimal settings!! for normal operations no problems!! But we are = doing=20
massive updates for some of big tables!! So we are using vb progra= ms=20
and connecting to the database thru odbc dsn. My first question is how = to=20
set transaction use rollback segment rbs_big? I tried to set as first s= tmt,=20
but its not using rbs_big segment, its using some other rollback segmen= t. Is=20
that good idea to make all my rollback segs maxextents unlimited to avo= id=20
maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw o= ne=20
time, one of my rbs segment extented 2gb and failed transaction with=20
maxextents reached with 5m initial and next, minextents 20 and optimal=
100M.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any help will be appreciated</FONT></D=
IV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>venkat.</FONT></DIV></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<P>
<HR SIZE=3D1>
Yahoo! DSL</A> - Now only $29.95 per=20
month!</BLOCKQUOTE></BLOCKQUOTE><CODE><FONT SIZE=3D3><BR>
<BR>
________________________________________________________________________<BR>
 |
 |