Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback Segs
This is a multi-part message in MIME format.
------_=_NextPart_001_01C34B7B.01AD961C
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
=20
Yes you are right, sorry but I made a mistake, since we are using = Baan IVc4 which works against Oracle we have no means to interfere with = its transactions when they are commited to Oracle and we can not modify = them so that it uses a specific rollback segment, so the only way for us = to do it is to disable all except the one we want it to use.
-----Mensaje original-----
De: Lee Cullip [mailto:Lee.Cullip_at_three.co.uk]
Enviado el: mi=E9rcoles, 16 de julio de 2003 10:54
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Rollback Segs
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.=
com/sbc/> Yahoo! DSL - Now only $29.95 per month!
This e-mail message (including any attachment) is intended only for the =
personal=20
use of the recipient(s) named above. This message is confidential and =
may be=20
legally privileged. If you are not an intended recipient, you may not =
review, 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 =
only.=20
Furthermore, this message (including any attachment) does not create any =
legally=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 =
Hutchison=20
3G UK Limited.
------_=_NextPart_001_01C34B7B.01AD961C
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><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV> <DIV> <SPAN class=3D766261509-16072003><FONT =face=3DArial=20
size=3D2>-----Original Message-----<BR><B>From:</B> Fermin Bernaus=20 [mailto:fbernaus_at_sammic.com]<BR><B>Sent:</B> 16 July 2003=20 09:09<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B>=20
RE: Rollback 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=20
know, 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 only=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=20
size=3D2></FONT></SPAN> </DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=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 julio=20 de 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=20 doing massive updates for some of big tables!! So we are = using vb=20 programs and connecting to the database thru odbc dsn. My first = question=20 is how to set transaction use rollback segment rbs_big? I tried to = set as=20 first stmt, but its not using rbs_big segment, its using some = other=20 rollback segment. Is that good idea to make all my rollback segs=20 maxextents unlimited to avoid maxextents reached error?? I have = lot of rbs=20 space nearly 10Gb. I saw one time, one of my rbs segment extented = 2gb and=20 failed transaction with maxextents reached with 5m initial and = next,=20 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></DIV> <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> Do you Yahoo!?<BR><A=20 =
Yahoo! DSL</A> - Now only $29.95 per=20 month!</BLOCKQUOTE></BLOCKQUOTE><CODE><FONT=20 =
size=3D3><BR><BR>________________________________________________________= ________________<BR><BR>This=20
communication in error, please notify <BR>us immediately by e-mail and =
delete=20
the original message.<BR><BR>Any views or opinions expressed in this =
message=20
are those of the author only. <BR>Furthermore, this message (including =
any=20
attachment) does not create any legally <BR>binding rights or =
obligations=20
whatsoever, which may only be created by the exchange <BR>of hard copy =
documents signed by a duly authorised representative of Hutchison = Received on Wed Jul 16 2003 - 04:16:57 CDT
![]() |
![]() |