Home » RDBMS Server » Server Administration » why RBS need 2 atleast extents (oracle 9i windows 2000)
why RBS need 2 atleast extents [message #455502] Tue, 11 May 2010 22:40 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
why RBS need 2 atleast extents
Re: why RBS need 2 atleast extents [message #455507 is a reply to message #455502] Tue, 11 May 2010 23:27 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Very Nice Article wallacel -- Thanks for the question regarding "rollback segment", version 8.1.6

From Above Article

Quote:
Followup July 17, 2003 - 10am Central time zone:

if you have one extent
and you set max extents to one

then you would jam the transaction at the end of the rbs each and every time.

hence ONE is not a good number at all for rollback segments

hence ONE is not a permitted number for rollback segments

TWO is the minimum.


if we let you use one, someone would set maxextents to one and get errors constantly, and say
"stupid database". so we just don't let that happen.


hope you got the Answer you are looking for.

Good Luck.
Re: why RBS need 2 atleast extents [message #455511 is a reply to message #455502] Tue, 11 May 2010 23:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
One question, why do you care about rollback segments when automatic undo has been introduced 10 years ago, in version 9.0?

Regards
Michel

[Updated on: Tue, 11 May 2010 23:43]

Report message to a moderator

Re: why RBS need 2 atleast extents [message #455516 is a reply to message #455511] Wed, 12 May 2010 00:51 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
@reyazan if you would have given 4 digit oracle version number , Question would be more easy to Answer.
Previous Topic: Grant Syntax
Next Topic: Copying files error while Oracle 11g R2 Installation
Goto Forum:
  


Current Time: Sun May 19 16:40:05 CDT 2024