Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> automatic undo management vs rollback segs (9i)
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