RE: Rollback Segments Errors

Hi Rich,

No, there is no problem with reusing the same rollback segment name when dropping and recreating a rollback segment. Internally, Oracle does everything using the undo segment number instead of the name.

Interestingly, Oracle reuses undo segment numbers too. When you drop a rollback segment, its row is not deleted from UNDO$. The STATUS$ column is just changed to 1 and the wrap number and sequence number are retained. When you then create another rollback segment (using the same or any other name) it will get the same undo segment number and the wrap and sequence numbers will start where the equivalent number for the previous rollback segment of the same number stopped (unless the wrap number was already too high to permit more transactions). This of course necessary so that old row level locks once held by transactions assigned to the previous rollback segment of that number can successfully be cleaned out.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Sent: Friday, 10 November 2000 5:35
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