Message-Id: <25937.337988@fatcity.com> From: "Fermin Bernaus" Date: Wed, 16 Jul 2003 11:16:57 +0200 Subject: 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@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@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@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 = 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

Yes you are right, sorry but I made a mistake, = since we are=20 using Baan IVc4 which works against Oracle we have no means to interfere = with=20 its transactions when they are commited to Oracle and we can not modify = them so=20 that it uses a specific rollback segment, so the only way for us to do = it is to=20 disable all except the one we want it to use.

-----Mensaje original-----
De: Lee Cullip=20 [mailto:Lee.Cullip@three.co.uk]
Enviado el: mi=E9rcoles, 16 = de julio=20 de 2003 10:54
Para: Multiple recipients of list=20 ORACLE-L
Asunto: RE: Rollback Segs

set=20 transaction use rollback segment xxxx only works if it's the first = statement=20 in your transaction, an easy way to make sure this is the case is to = issue a=20 commit directly before issuing this statement.

I=20 believe this has been a feature of Oracle since way back in version 7 = (Correct=20 me if I'm wrong).

Hope=20 this helps.

Cheers

Lee

-----Original Message-----
From: Fermin Bernaus=20 [mailto:fbernaus@sammic.com]
Sent: 16 July 2003=20 09:09
To: Multiple recipients of list = ORACLE-L
Subject:=20 RE: Rollback Segs

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.

-----Mensaje original-----
De: venkat Rama=20 [mailto:techsqlca@yahoo.com]
Enviado el: mi=E9rcoles, 16 = de julio=20 de 2003 6:34
Para: Multiple recipients of list=20 ORACLE-L
Asunto: Rollback Segs

Hi Friends,

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.

Any help will be = appreciated

Thanks

venkat.

Do you Yahoo!?
SBC=20 Yahoo! DSL - Now only $29.95 per=20 month!
________________________________________________________= ________________ This=20 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=20 be legally privileged. If you are not an intended recipient, you = may not=20 review, copy or distribute this message. If you have received this = communication in error, please notify us immediately by e-mail and = delete=20 the original message. Any views or opinions expressed in this = message=20 are those of the author only. Furthermore, this message (including = any=20 attachment) does not create any legally binding rights or = obligations=20 whatsoever, which may only be created by the exchange of hard copy = documents signed by a duly authorised representative of Hutchison =