| 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 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_at_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 =
<http://pa.yahoo.com/*http://rd.yahoo.com/evt=3D1207/*http://promo.yahoo.=
com/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
<!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 5.50.4611.1300" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D765112205-16072003><FONT face=3DArial>Ave =
!</FONT></SPAN></DIV>
<DIV><SPAN class=3D765112205-16072003><FONT =
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D765112205-16072003><FONT face=3DArial>Is there any =
reason not to=20
keep maxextents always unlimited :) Extentsize =
should</FONT></SPAN></DIV>
<DIV><SPAN class=3D765112205-16072003><FONT face=3DArial>be reasonable =
of=20
course.</FONT></SPAN></DIV>
<DIV><SPAN class=3D765112205-16072003><FONT =
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D765112205-16072003><FONT =
face=3DArial>Br.</FONT></SPAN></DIV>
<DIV><SPAN class=3D765112205-16072003><FONT =
face=3DArial>Jorma</FONT></SPAN></DIV>
<DIV><FONT face=3DArial></FONT> </DIV>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> ext venkat Rama=20
[mailto:techsqlca_at_yahoo.com]<BR><B>Sent:</B> 16 July, 2003 =
07:34<BR><B>To:</B>=20
Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Rollback=20
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 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.</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
href=3D"http://pa.yahoo.com/*http://rd.yahoo.com/evt=3D1207/*http://promo=
.yahoo.com/sbc/">SBC=20
Received on Wed Jul 16 2003 - 00:25:03 CDT
 |
 |