Message-Id: <25929.337934@fatcity.com> From: Date: Wed, 16 Jul 2003 08:25:03 +0300 Subject: RE: Rollback Segs This is a multi-part message in MIME format. ------_=_NextPart_001_01C34B5A.9C5965BD Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Ave ! =20 Is there any reason not to keep maxextents always unlimited :) = Extentsize should be reasonable of course. =20 Br. Jorma =20 -----Original Message----- From: ext venkat Rama [mailto:techsqlca@yahoo.com] Sent: 16 July, 2003 07:34 To: Multiple recipients of list ORACLE-L Subject: 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_01C34B5A.9C5965BD Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Ave = !

Is there any = reason not to=20 keep maxextents always unlimited :) Extentsize = should

be reasonable = of=20 course.

Br.

Jorma

-----Original Message-----
From: ext venkat Rama=20 [mailto:techsqlca@yahoo.com]
Sent: 16 July, 2003 = 07:34
To:=20 Multiple recipients of list ORACLE-L
Subject: Rollback=20 Segs

Hi Friends,

I have 150Gb database with 30 rollback = segs with=20 optimal settings!! for normal operations no problems!! But we are doing = massive=20 updates for some of big tables!! So we are using vb programs and = connecting=20 to the database thru odbc dsn. My first question is how to set = transaction use=20 rollback segment rbs_big? I tried to set as first stmt, but its not = using=20 rbs_big segment, its using some other rollback segment. Is that good = idea to=20 make all my rollback segs maxextents unlimited to avoid maxextents = reached=20 error?? I have lot of rbs space nearly 10Gb. I saw one time, one of my = rbs=20 segment extented 2gb and failed transaction with maxextents reached with = 5m=20 initial and next, minextents 20 and optimal 100M.

Any help will be = appreciated

Thanks

venkat.

Do you Yahoo!?
SBC=20