Re: Increase the size of rollback segments

In article <8s7hrm$vho$1_at_nnrp1.deja.com>,   aschex_at_my-deja.com wrote:
> I've created several rollback segments with the following options:
> initial 512k next 512k minextents 20 maxextents 200 optimal 50m
>
> The problem I'm running into is I'm getting snapshot too old error.
 I've
> checked the size of my rollback segments and they are each about 10-20
> megs in size. What I would like to do is increase the size of each
> rollback segment to about 50 megs in size. Is there an easy way of
> allocating additional extents to a rollback segment? I was hoping to
> avoid dropping and recreating the rollback segs.
>
> Thanks for your help,
> Andy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Since you cannot alter the MINEXTENTS setting for the segment I believe you have no other choice except to recreate the segment with a larger MINEXTENTS value.

--
David Fitzjarrell
Oracle Certified DBA


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