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 -> undo management vs. rollback segments in 9i

undo management vs. rollback segments in 9i

From: Rob <robw_at_physics.umd.edu>
Date: Thu, 01 Apr 2004 17:27:26 -0500
Message-ID: <406C974E.BE1833B5@physics.umd.edu>


Apparently 9i has a new parameter
undo_management = AUTO or MANUAL
for redo log files

Does anyone have any experience using the new type of rollback segments and do they work well?
Also if Oracle does the work does it put the RBS on SYSTEM tablespace and can it be moved to non system tablespaces after your DB is created.

If not are all the old ways of doing things the same? ie

Startup nomount with a parameter file with RB1 thru RBn commented out

create instance and database
create another system RBS an bring online run catalog.sql/catproc.sql
create tablespaces ( including RBS tablespace ) create RBS1 ....RBSn on RBS tablespace
bring RB1 online
bring RB0 ( system tablespace ) offline
shutdown instance
startup with new parameter file with RB1...RBn uncommented bringing them online

Has this changed in any way

Thankyou

Rob

DBA
University of Maryland
Physics Received on Thu Apr 01 2004 - 16:27:26 CST

Original text of this message

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