Home » RDBMS Server » Server Administration » Rollback Segments: initial and next sizes
Rollback Segments: initial and next sizes [message #60124] Fri, 16 January 2004 14:14 Go to next message
Knm Dibba
Messages: 3
Registered: January 2004
Junior Member
Hi Everybody. Oracle recommends that the initial and next extent sizes be same for the rollback segments.

can you comment, on why is this recommended.

Thanks in advance!

Report message to a moderator

Re: Rollback Segments: initial and next sizes [message #60131 is a reply to message #60124] Sat, 17 January 2004 05:46 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Extents in Rollback segments unlike Table/Index/Sort segments are used in circular fashion and hence we do not need a linear(or any sort of) growth induced by non-zero pctincrease(not that we need this in other segment types!).
Also note that the extents in rollback segments get allocated/deallocated (if you use optimal or a dbms_job or manual etc) more frequently than in any other segment type and so its easier to maintain when they are equi-sized.

In 9i,using automatic undo management relieves a lot of manual work required in sizing them.

-Thiru

Report message to a moderator

Previous Topic: Need few mock questions for DBA certifications
Next Topic: Net8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:44:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.