RE: Rollback Segments Errors

Rich,

That doesn't seem to make sense. When you take a rollback segment off line, the instance waits until any transactions that are involved with using that segment have finished. Rollback segments, although permanent, contain temporary data. Once that data has been acted upon, the record of any change is written to the redo logs, which are ultimately archived. I could see your instructor's point if he was referring to unarchived redo logs.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Sent: Thursday, November 09, 2000 1: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).