OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » undo tasblespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

undo tasblespace [message #63824]

Wed, 10 November 2004 10:51

Kapil
Messages: 145
Registered: May 2002

Senior Member

We upgraded from oracle 8i to 9i recently, I am still using rollback segments, in order to get rid of rollback segments and start using undo tablepsace, what parameter I should set in init.ora file and how many undo tablespaces I should create? Right now I have one 500M rollback segment and 4 small rollback segments sum(4 small rbs)= 500meg. How many undo tablespaces and sizes would be good to have for my all rbs .

Thanks for the help

�

Report message to a moderator

Re: undo tasblespace [message #63825 is a reply to message #63824]

Wed, 10 November 2004 19:48

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

You can only have one active UNDO tablespace at a
time. I would create it with the same size as your
old Rollback tablespace (although some say that it
can be somewhat smaller). For more info, see
http://www.orafaq.net/articles/archives/000009.htm

Best regards.

Frank

Report message to a moderator

Re: undo tasblespace [message #63827 is a reply to message #63825]

Thu, 11 November 2004 04:56

Kapil
Messages: 145
Registered: May 2002

Senior Member

what will happen to my rollback segments parameters, should i comment them in init.ora or what?

************************************************
transactions_per_rollback_segment 5
max_rollback_segments 30
rollback_segments RBS01, RBS02, RBS03, RBS04
fast_start_parallel_rollback LOW

Report message to a moderator

Re: undo tasblespace [message #63828 is a reply to message #63827]

Thu, 11 November 2004 20:55

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

Hi,

Since every database should have 1 undo tablespace...

if you want you can comment those parameters,butr it always recommanded to commet it.

once you specify the undo tablespace parameter it server will simply ignore's rollback segment parameters.

Report message to a moderator