Message-Id: <25929.337940@fatcity.com> From: "Fermin Bernaus" Date: Wed, 16 Jul 2003 09:08:27 +0200 Subject: RE: Rollback Segs This is a multi-part message in MIME format. ------_=_NextPart_001_01C34B69.0E38021C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =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! ------_=_NextPart_001_01C34B69.0E38021C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Which database version are you using? as long = as I know, at=20 least on Oracle 8.0.6 you can not specify which rollback segment a = particular=20 transaction should use. We disable all rollback segments and only enable = those=20 which we know won't make big updates / deletes = crash.

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

Hi Friends,

I have 150Gb database with 30 = rollback segs with=20 optimal settings!! for normal operations no problems!! But we are = doing=20 massive updates for some of big tables!! So we are using vb = programs and=20 connecting to the database thru odbc dsn. My first question is how to = set=20 transaction use rollback segment rbs_big? I tried to set as first = stmt, but=20 its not using rbs_big segment, its using some other rollback segment. = Is that=20 good idea to make all my rollback segs maxextents unlimited to avoid=20 maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw = one=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.

Any help will be = appreciated

Thanks

venkat.

Do you Yahoo!?
SBC=20