Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback Segments Errors

RE: Rollback Segments Errors

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 9 Nov 2000 14:55:39 -0500
Message-Id: <10675.121625@fatcity.com>


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

http://www.qode.com

"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&nbsp; 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>&quot;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.&quot;</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.&nbsp; =
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.&nbsp; :)</FONT>
</P>

<P><FONT SIZE=3D2>Rich =
Jesse&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; System/Database Administrator</FONT>
<BR><FONT =
SIZE=3D2>Rich.Jesse_at_qtiworld.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Quad/Tech International, Sussex, WI =
USA</FONT>
</P>

<P><FONT SIZE=3D2>&gt; -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>&gt; 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>&gt; Sent: Thursday, November 09, 2000 12:31</FONT>
<BR><FONT SIZE=3D2>&gt; To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; Subject: RE: Rollback Segments Errors</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Hi Larry,</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; You cannot alter minextents to grow a rollback =
segment. To </FONT>
<BR><FONT SIZE=3D2>&gt; get from 4 extents to</FONT>
<BR><FONT SIZE=3D2>&gt; 10, you have drop and recreate the rollback =
segment, or use </FONT>
<BR><FONT SIZE=3D2>&gt; it for a big</FONT>
<BR><FONT SIZE=3D2>&gt; transaction first.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; @&nbsp;&nbsp; Regards,</FONT>
<BR><FONT SIZE=3D2>&gt; @&nbsp;&nbsp; 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>&nbsp; INET: Rich.Jesse_at_qtiworld.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US