Re: Rollback/Undo in 9i

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 06 Apr 2005 22:45:16 -0700
Message-ID: <1112852494.95348@yasure>

DW wrote:

> Hm... got the tablespace made, got the AUM set to Auto - would you
> recommend eliminating the rollback tablespaces altogether?
> 
> DW

Yes with one exception. Do not remove the SYSTEM segent in the SYSTEM tablespace.

Even in 10g with UNDO one should see something like this: SQL> select segment_name, tablespace_name

2 from dba_rollback_segs;

SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ---------------
SYSTEM                         SYSTEM


_SYSSMU1$                      UNDOTBS1

_SYSSMU2$                      UNDOTBS1

_SYSSMU3$                      UNDOTBS1

_SYSSMU4$                      UNDOTBS1

_SYSSMU5$                      UNDOTBS1

_SYSSMU6$                      UNDOTBS1

_SYSSMU7$                      UNDOTBS1

_SYSSMU8$                      UNDOTBS1

_SYSSMU9$                      UNDOTBS1

_SYSSMU10$                     UNDOTBS1


SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ---------------


_SYSSMU11$                     UNDOTBS1

_SYSSMU12$                     UNDOTBS1

_SYSSMU13$                     UNDOTBS1

_SYSSMU14$                     UNDOTBS1

_SYSSMU15$                     UNDOTBS1

_SYSSMU16$                     UNDOTBS1

_SYSSMU17$                     UNDOTBS1

_SYSSMU18$                     UNDOTBS1

_SYSSMU19$                     UNDOTBS1

_SYSSMU20$                     UNDOTBS1

_SYSSMU21$                     UNDOTBS1

SYS still needs its RBS for the data dictionary.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Apr 07 2005 - 00:45:16 CDT