Re: changing rollback segment initial extent

In article <8oiq62$vt9$1_at_nnrp1.deja.com>,   jeeju_s_at_my-deja.com wrote:
> What you planed is right. You can go ahead with that. Only thing
> you have to take care is while making offline drop just make sure
> its become offline. Becoz it will take some time to become offline
> since its used online.
>
> Jeeju
>
> In article <8oha6a$9u7$1_at_nnrp1.deja.com>,
> irenekam_at_my-deja.com wrote:
> > Hi all,
> >
> > Problem: I need to increase the initial extent of serveral existing
> > rollback segments. Since I cannot alter the initial extent of an
> > existing rollback segment, I plan to do the following:
> >
> > 1) offline the rollback segment
> > 2) drop the rollback segment
> > 3) create a new rollback segment having the same name as the old
> > rollback segment and with new values for initial and next extents
> > 4) online this new rollback segment
> >
> > I will need to perform this procedure on a live (production)
 database.
> >
> > My questions: Do you see any potential problems with this plan?
 Faults?
> > Especially concerning performance since this is a live database?
> > I have 4 rollback segments in my database. I will apply this plan
 to
> > each individual rollback segment one at a time. If this plan will
 not
> > work, do you have any suggestions as to how I can change the initial
> > extents on the rollback segments in a live database?
> >
> > I am a newbie so thanks in advance for any suggestions and
 comments!!
> >
> > Irene
> >

You may want to look at your rbs tablespace fragmentation and freespace pattern before you start. You may find it useful to coalesce the tablespace before you start and after each drop to minimize creating free space chunks too small to be used with your new extent sizes.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.