Home » RDBMS Server » Server Administration » default size of rollback and undo space
default size of rollback and undo space [message #169364] Wed, 26 April 2006 07:52 Go to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
i am going to create one new database.the size is 10gb ..then

howmuch size(default) is allocated for rollback segments and

undo space ??

Report message to a moderator

Re: default size of rollback and undo space [message #169380 is a reply to message #169364] Wed, 26 April 2006 08:55 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Start creating your DB with the DBCA utility and accept the default proposed UNDO tablespace size. You can always increase it later if you run into problems.

Report message to a moderator

Re: default size of rollback and undo space [message #169385 is a reply to message #169380] Wed, 26 April 2006 09:44 Go to previous messageGo to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
is there any formula to calculate default size of undo space and
segment space ???...

Report message to a moderator

Re: default size of rollback and undo space [message #169430 is a reply to message #169364] Wed, 26 April 2006 16:47 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
According to me UNDO has no relation with the size of the database, it totally depends on the type and amount of transactions against the database. You can control the behavior of UNDO management by init parameters like UNDO_RETENTION etc or in 10g R2 you can let oracle manage all this for you and you can increase/decrease the size of UNDO at any point if needed. There is no thumb rule which we can follow to configure the UNDO in first shot, it needs thorough testing and lots of experience.

Daljit Singh

Report message to a moderator

Previous Topic: granule size
Next Topic: COMPATIBILITY
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 02:28:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.