| 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 Segments Errors
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C04A87.091F6D0E
Content-Type: text/plain;
charset="iso-8859-1"
Isn't that why each rollback segment has a unique USN#?
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
Sent: Thursday, November 09, 2000 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Rollback Segments Errors
Hmmmmm...I was told by my Oracle Perf Tuning class guru that any new RBS must not have the same name as a previous one. His reasoning was that it could cause problems with recovery, should it be needed.
Albeit, this is presented as heresay, and therefore cannot be admitted as evidence. :)
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
> -----Original Message-----
> From: Steve Adams [mailto:steve.adams_at_ixora.com.au]
> Sent: Thursday, November 09, 2000 12:31
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rollback Segments Errors
>
>
> Hi Larry,
>
> You cannot alter minextents to grow a rollback segment. To
> get from 4 extents to
> 10, you have drop and recreate the rollback segment, or use
> it for a big
> transaction first.
>
> @ Regards,
> @ Steve Adams
This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C04A87.091F6D0E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Rollback Segments Errors</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Isn't that why each rollback segment has a unique = USN#?</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Jesse, Rich [<A = HREF=3D"mailto:Rich.Jesse_at_qtiworld.com">mailto:Rich.Jesse_at_qtiworld.com</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, November 09, 2000 2:35 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: Rollback Segments Errors</FONT> </P> <BR> <P><FONT SIZE=3D2>Hmmmmm...I was told by my Oracle Perf Tuning class = guru that any new RBS</FONT> <BR><FONT SIZE=3D2>must not have the same name as a previous one. = His reasoning was that it</FONT> <BR><FONT SIZE=3D2>could cause problems with recovery, should it be = needed.</FONT> </P> <P><FONT SIZE=3D2>Albeit, this is presented as heresay, and therefore = cannot be admitted as</FONT> <BR><FONT SIZE=3D2>evidence. :)</FONT> </P> <P><FONT SIZE=3D2>Rich = Jesse &= nbsp; &= nbsp; System/Database Administrator</FONT> <BR><FONT = SIZE=3D2>Rich.Jesse_at_qtiworld.com &nbs= p; Quad/Tech International, Sussex, WI = USA</FONT> </P> <P><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> From: Steve Adams [<A = HREF=3D"mailto:steve.adams_at_ixora.com.au">mailto:steve.adams_at_ixora.com.au= </A>]</FONT> <BR><FONT SIZE=3D2>> Sent: Thursday, November 09, 2000 12:31</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> Subject: RE: Rollback Segments Errors</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Hi Larry,</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> You cannot alter minextents to grow a rollback = segment. To </FONT> <BR><FONT SIZE=3D2>> get from 4 extents to</FONT> <BR><FONT SIZE=3D2>> 10, you have drop and recreate the rollback = segment, or use </FONT> <BR><FONT SIZE=3D2>> it for a big</FONT> <BR><FONT SIZE=3D2>> transaction first.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> @ Regards,</FONT> <BR><FONT SIZE=3D2>> @ Steve Adams</FONT> </P> <BR> <P><FONT = SIZE=3D2>---------------------------------------------------------------= ---------</FONT> </P> <P><FONT SIZE=3D2>This message has been scanned for viruses with Trend = Micro's Interscan VirusWall.</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Jesse, Rich</FONT> <BR><FONT SIZE=3D2> INET: Rich.Jesse_at_qtiworld.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Thu Nov 09 2000 - 13:55:39 CST
 |
 |