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

Home -> Community -> Usenet -> c.d.o.server -> automatic undo management vs rollback segs (9i)

automatic undo management vs rollback segs (9i)

From: Rob <robw_at_physics.umd.edu>
Date: Thu, 01 Apr 2004 17:09:10 -0500
Message-ID: <406C9306.17CC8189@physics.umd.edu>


Apparently 9i has some new version of rollback segments called undo management.
Does anyone have any experience with this and is it worth using. I run a small DB
< 3G total not tons of transactions or concurrnet users If it is good does the tablespace reside on SYSTEM tablespace and can you change that since Oracle has always advised against using SYSTEM for anything other than Oracle Stuff.

If it not a great new tool do you use the same old methods to create Rollback segments as before (8.1.5). ie

Use the system rollback for early instance and database creation then
create an additional RBS on system and bring online run catalog.sql and catproc.sql
create tablespaces including an RBS tablespace create new RB segs and bring system rollback seg offline shutdown and restart instance with new parameter file with RB1,RB2....RBn uncommented which will bring them all online

? has that changed if you decide to use UNDO_MANAGEMENT = MANUAL

Thanks
Rob Received on Thu Apr 01 2004 - 16:09:10 CST

Original text of this message

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