| 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_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_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!
------_=_NextPart_001_01C34B69.0E38021C
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=3D277150407-16072003><FONT =face=3DArial=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 de=20
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 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.</FONT></DIV>
 |
 |