Message-Id: <10675.121625@fatcity.com> From: "Koivu, Lisa" Date: Thu, 9 Nov 2000 14:55:39 -0500 Subject: 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 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@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@qtiworld.com Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Steve Adams [mailto:steve.adams@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@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@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 RE: Rollback Segments Errors

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@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           &= nbsp;           &= nbsp;  System/Database Administrator
Rich.Jesse@qtiworld.com      &nbs= p;      Quad/Tech International, Sussex, WI = USA

> -----Original Message-----
> From: Steve Adams [mailto:steve.adams@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@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@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 =